From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
---|---|
To: | bobJobS <russelljanusz(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Streaming Replication - Error on Standby |
Date: | 2014-02-11 20:00:50 |
Message-ID: | 52FA8172.80807@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(dot)klaver(at)gmail(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2014-02-11 20:03:34 | Re: Streaming Replication - Error on Standby |
Previous Message | John R Pierce | 2014-02-11 19:53:09 | Re: |