Re: Streaming Replication - Error on Standby - Mailing list pgsql-general

From Adrian Klaver
Subject Re: Streaming Replication - Error on Standby
Date
Msg-id 52FA8172.80807@gmail.com
Whole thread Raw
In response to Streaming Replication - Error on Standby  (bobJobS <russelljanusz@yahoo.com>)
List pgsql-general
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 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?

Look at this tutorial:

https://wiki.postgresql.org/wiki/Binary_Replication_Tutorial



--
Adrian Klaver
adrian.klaver@gmail.com


pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re:
Next
From: Adrian Klaver
Date:
Subject: Re: Streaming Replication - Error on Standby