Re: [GENERAL] Streaming Replication - Error on Standby

2014-02-12 Thread bobJobS
Thanks for the information and the URLs! -- View this message in context: http://postgresql.1045698.n5.nabble.com/Streaming-Replication-Error-on-Standby-tp5791463p5791588.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list

[GENERAL] Streaming Replication - Error on Standby

2014-02-11 Thread bobJobS
Postgres 9.3.2. RHEL 5 After performing all of the Streaming Replication setup steps, I get the following error message in my standby DB log file. database system identifier differ between the primary and standby I've double checked the recovery.conf file and it contains the correct hostname,

Re: [GENERAL] Streaming Replication - Error on Standby

2014-02-11 Thread bricklen
On Tue, Feb 11, 2014 at 10:12 AM, bobJobS russelljan...@yahoo.com wrote: Postgres 9.3.2. RHEL 5 After performing all of the Streaming Replication setup steps, What replication steps? database system identifier differ between the primary and standby How did you take the initial backup

Re: [GENERAL] Streaming Replication - Error on Standby

2014-02-11 Thread bobJobS
To get the standby server to a point, I tool a globals dump and a data dump of the primary server and build the standby. Then I executed pg_startbackup, rsync data dir to standby data dir (to catch any changes made while I was building the standby) and finally pg_stopbackup... all on the

Re: [GENERAL] Streaming Replication - Error on Standby

2014-02-11 Thread bricklen
On Tue, Feb 11, 2014 at 11:25 AM, bobJobS russelljan...@yahoo.com wrote: To get the standby server to a point, I tool a globals dump and a data dump of the primary server and build the standby. Then I executed pg_startbackup, rsync data dir to standby data dir (to catch any changes made

Re: [GENERAL] Streaming Replication - Error on Standby

2014-02-11 Thread Adrian Klaver
On 02/11/2014 10:12 AM, bobJobS wrote: Postgres 9.3.2. RHEL 5 After performing all of the Streaming Replication setup steps, I get the following error message in my standby DB log file. database system identifier differ between the primary and standby I've double checked the recovery.conf

Re: [GENERAL] Streaming Replication - Error on Standby

2014-02-11 Thread Adrian Klaver
On 02/11/2014 10:12 AM, bobJobS wrote: Postgres 9.3.2. RHEL 5 After performing all of the Streaming Replication setup steps, I get the following error message in my standby DB log file. database system identifier differ between the primary and standby I've double checked the recovery.conf