Re: [GENERAL] Using of replication by initdb for both nodes? - Mailing list pgsql-admin

From Michael Paquier
Subject Re: [GENERAL] Using of replication by initdb for both nodes?
Date
Msg-id CAB7nPqSxeMSYArLQ4Y0xb5CvS3fZyoC0qGZsSSqCkQb6=UBwjA@mail.gmail.com
Whole thread Raw
In response to Using of replication by initdb for both nodes?  (Bocap <kakalot4_9@yahoo.com>)
List pgsql-admin
On Thu, Aug 29, 2013 at 11:06 PM, Bocap <kakalot4_9@yahoo.com> wrote:
> 1. Instead of using pg_basebackup for standby DB, i initdb for both standby
> and primary.
> 2. Create recovery.conf in standby DB, and start both nodes.
> Now it work fine for me, but is it sure that no problem?
A standby node *needs* to be based on a base backup of its primary or
the node it connects to (it can be as well a slave in a cascading
configuration). One of the reasons being that they need to share the
same system identifier (Database system identifier output in
pg_controldata). Using initdb on multiple nodes to set up a cluster
will simply not satisfy this condition, and your cluster setup will
fail. More details here:
http://www.postgresql.org/docs/9.2/static/continuous-archiving.html
--
Michael


pgsql-admin by date:

Previous
From: Richie Vazquez
Date:
Subject: FW: Removal of $PGDATA/base files that existed before streaming replication (v9.2.4)
Next
From: Technical Doubts
Date:
Subject: to_timestamp error between postgres version 8.3 and 9.2