s
Size: a a a
s
s
s
s
s
AM
s
s
s
s
s
s
if [ ! -s "$PGDATA/PG_VERSION" ]; then
# Prepare REPLICA
if [ -n "$PG_SLOT" ] && [ -n "$PG_MASTER_HOST" ]; then
# Configure connecton for pg_basebackup and psql create replication slot
echo "$PG_MASTER_HOST:5432:*:$POSTGRES_USER:$POSTGRES_PASSWORD" > ~/.pgpass
chmod 0600 ~/.pgpass
NUM_ATTEMPTS=20
n=0
until [ $n -ge $NUM_ATTEMPTS ]
do
pg_basebackup -D $PGDATA -Fp -U $POSTGRES_USER -w -R -Xs -c fast -l 'clone' -P -v -h $PG_MASTER_HOST -U $POSTGRES_USER && export RESTORED=1 && break
n=$[$n+1]
echo "Not ready; Sleep $n"
sleep $n
done
# Create replication slot
psql -h $PG_MASTER_HOST -U $POSTGRES_USER -w -c "SELECT pg_create_physical_replication_slot('$PG_SLOT');" || echo "may be exists"
# Prepare recovery.conf
echo "primary_slot_name = '$PG_SLOT'" >> "$PGDATA/standby.signal"
echo "primary_conninfo = 'host=$PG_MASTER_HOST port=5432 user=$POSTGRES_USER password=$POSTGRES_PASSWORD'" >> "$PGDATA/standby.signal"
#echo "restore_command = '/opt/pgpro/std-12/bin/wal-g wal-fetch %f %p'" >> "$PGDATA/standby.signal"
echo
echo 'PostgreSQL clone process complete; ready for start up.'
echo
s
s
s
s
"host replication $POSTGRES_USER 0.0.0.0/0 md5"
s
ВК
s