On Mon, May 14, 2012 at 8:18 AM, chinnaobi <chinnaobi@gmail.com> wrote:
> I do base backup only first time on standby when it is going to be
> replicated. when ever primary goes down, standby becomes primary and
> primary becomes standby when primary comes up. When primary becomes standby
> I am restoring data from WAL archive and start postgres service streaming
> replication to connect to primary.
>
> This setup is working.
I don't think this is safe. The primary might have WAL that never
made it to the standby, in which case the two machines will be out of
sync with each other and all sorts of bad stuff could happen.
--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company