Search Postgresql Archives

Streaming Replication - Error on Standby

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

 



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.


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[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