Re: Problems starting slave

[Ron <ronljohnsonjr@xxxxxxxxx>]

    On 10/3/23 09:37, Douglas Reed wrote:

Hi the full pg_basebackup command was;

    pg_basebackup -h 172.110.6.5 -D /var/lib/pgsql/12/data -R -U postgres --wal-method=stream

    I get consistently successful results in v15 using this set of
    commands (where the service options reference the primary server in
    .pg_service_conf):

psql service=primary -c "select pg_drop_replication_slot(slot_name) from pg_replication_slots where slot_name = 'pgstandby1';"

/usr/bin/rm -r $PGDATA/*

      pg_basebackup --dbname=service=basebackup -D $PGDATA --progress
      --checkpoint=fast -v \
              --write-recovery-conf --wal-method=stream --create-slot
      --slot=pgstandby1 --compress=server-zstd
      
      pg_ctl start -wt90 
    
    zstd compression might not be supported by v12.

--
Born in Arizona, moved to Babylonia.