mirror of
https://github.com/jambonz/jambonz-infrastructure.git
synced 2026-10-12 19:04:11 +00:00
44 lines
1.9 KiB
Bash
44 lines
1.9 KiB
Bash
#!/bin/bash
|
|
DISTRO=$1
|
|
|
|
if [ "$2" == "yes" ]; then
|
|
|
|
DB_USER=$3
|
|
DB_PASS=$4
|
|
RHEL_RELEASE
|
|
|
|
if [[ "$DISTRO" == rhel* ]] ; then
|
|
RHEL_RELEASE="${DISTRO:5}"
|
|
|
|
sudo dnf install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-${RHEL_RELEASE}-x86_64/pgdg-redhat-repo-latest.noarch.rpm
|
|
dnf -qy module disable postgresql
|
|
sudo dnf install -y postgresql12 postgresql12-server
|
|
|
|
sudo /usr/pgsql-12/bin/postgresql-12-setup initdb
|
|
sudo systemctl enable postgresql-12
|
|
sudo systemctl start postgresql-12
|
|
else
|
|
wget -q https://www.postgresql.org/media/keys/ACCC4CF8.asc -O- | sudo apt-key add -
|
|
sudo sh -c 'echo "deb http://apt.postgresql.org/pub/repos/apt/ $(lsb_release -cs)-pgdg main" > /etc/apt/sources.list.d/postgresql.list'
|
|
sudo apt-get update
|
|
sudo apt-get install -y postgresql-12
|
|
sudo systemctl daemon-reload
|
|
sudo systemctl enable postgresql
|
|
sudo systemctl restart postgresql
|
|
fi
|
|
|
|
echo "creating database homer_config and homer_data with user ${DB_USER} and password ${DB_PASS}"
|
|
cd /tmp
|
|
sudo -u postgres psql -c "CREATE DATABASE homer_config;"
|
|
sudo -u postgres psql -c "CREATE DATABASE homer_data;"
|
|
sudo -u postgres psql -c "CREATE ROLE ${DB_USER} WITH SUPERUSER LOGIN PASSWORD '$DB_PASS';"
|
|
sudo -u postgres psql -c "GRANT ALL PRIVILEGES ON DATABASE homer_config to ${DB_USER};"
|
|
sudo -u postgres psql -c "GRANT ALL PRIVILEGES ON DATABASE homer_data to ${DB_USER};"
|
|
|
|
|
|
if [[ "$DISTRO" == rhel* ]] ; then
|
|
# change authentication to md5
|
|
sudo sed -i -e 's/^local all all peer/local all all md5/' -e 's/^host all all 127.0.0.1\/32 ident/host all all 127.0.0.1\/32 md5/' -e 's/^host all all ::1\/128 ident/host all all ::1\/128 md5/' /var/lib/pgsql/12/data/pg_hba.conf
|
|
fi
|
|
|
|
fi |