You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
18 lines
766 B
18 lines
766 B
#! /bin/sh
|
|
|
|
if [ "$(whoami)" != "root" ]; then
|
|
SUDO=sudo
|
|
fi
|
|
${SUDO} apt install -y postgresql
|
|
POSTGRES_VERSION=`apt show postgresql | grep Version | cut -d" " -f2 | cut -d"+" -f1`
|
|
read -p "Postgres Master IP: " -ei "" POSTGRES_MASTER
|
|
read -p "Postgres replica username: " -ei "replica_user" REPLICA_USER
|
|
read -p "Postgres replica password: " -ei "" REPLICA_PASS
|
|
|
|
${SUDO} systemctl stop postgresql
|
|
sudo -u postgres pg_conftool set primary_conninfo "host=$POSTGRES_MASTER port=5432 user=$POSTGRES_USER password=$POSTGRES_PASS"
|
|
sudo -u postgres pg_conftool set primary_slot_name replica_1
|
|
|
|
|
|
sudo -u postgres pg_basebackup -h $POSTGRES_MASTER -U -X stream -C -S replica_1 -v -R -W -D /var/lib/postgresql/$POSTGRES_VERSION/main/
|
|
${SUDO} systemctl start postgresql
|