Thread: Postgres 9.6 Slave Creation

Postgres 9.6 Slave Creation

From
Eric Katchan
Date:

Hello, 


We have recently upgraded our postgres cluster from 9.1 to 9.6.  we are having a difficult time creating our slave server.  We have encountered the "contrecord is requested" error which is preventing the slave from starting up.  We have recreated the slave , still no luck.  Our master is running apparently without issue.  We did not use the pg_basebackup command but the 


pg_start_backup

tar

pg_stop_backup



How can we debug?  I am afraid to stop and start our master server in case there is data corruption and it will not start.  I have however successfully restored the database using a pg_dump onto another machine  (I understand that this cannot be used for slave creation, I just wanted to verify that I could restore the new upgraded db).  Would it be better to use the streaming pg_basebackup command?


Please advise.

Eric

RE: Postgres 9.6 Slave Creation

From
Eric Katchan
Date:

Hello, a little follow up…

 

We attempted the same method one more time with no success.  Today we used  pg_basebackup.

Successfully created slave.

 

Eric