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 (pgsql

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 f

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 f

Re: [GENERAL] Streaming Replication - Error on Standby

2014-02-11 Thread bricklen
On Tue, Feb 11, 2014 at 11:25 AM, bobJobS 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 while I was buildin

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 primary

Re: [GENERAL] Streaming Replication - Error on Standby

2014-02-11 Thread bricklen
On Tue, Feb 11, 2014 at 10:12 AM, bobJobS 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 of the master? D

[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,