Streaming Replication - Error on Standby

From: bobJobS <russelljanusz(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Streaming Replication - Error on Standby
Date: 2014-02-11 18:12:57
Message-ID: 1392142377337-5791463.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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, port, username and password.

I've also verified that ssh into either the primaryor standby as the
replication user does not require a password.

When building the standby I took the latest backup from the primary and
loaded the standby. After, I executed the start backup command on the
primary, followed by rsync, then the stop backup command.

I've googled the heck out of the error message and I found only references
to invalid primary connection information.

Any ideas?

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Streaming-Replication-Error-on-Standby-tp5791463.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message bricklen 2014-02-11 19:17:31 Re: Streaming Replication - Error on Standby
Previous Message Steven Schlansker 2014-02-11 17:28:58 Re: [GENERAL]