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

From bricklen
Subject Re: Streaming Replication - Error on Standby
Date
Msg-id CAGrpgQ-xNGFyL00jN+RhfxRH0Fo_YedJyHX7524aRs8e7t8A1w@mail.gmail.com
Whole thread Raw
In response to Streaming Replication - Error on Standby  (bobJobS <russelljanusz@yahoo.com>)
Responses Re: Streaming Replication - Error on Standby
List pgsql-general
On Tue, Feb 11, 2014 at 10:12 AM, bobJobS <russelljanusz@yahoo.com> 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? Did you rsync the master filesystem (after issuing pg_start_backup()) or use pg_basebackup, or did you literally take a pg_dump of the master and try to turn that backup into a slave? If the latter, you will need to use the rsync/pg_basebackup method.

There are some reasonably thorough steps at http://dba.stackexchange.com/a/53546/24393 if you want to compare them against what you tried already.

pgsql-general by date:

Previous
From: bobJobS
Date:
Subject: Streaming Replication - Error on Standby
Next
From: bobJobS
Date:
Subject: Re: Streaming Replication - Error on Standby