Search Postgresql Archives

Postgres 9.6 Slave Creation

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux