Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes?

From: Douglas J Hunley <doug(dot)hunley(at)gmail(dot)com>
To: David Guyot <david(dot)guyot(at)europecamions-interactive(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes?
Date: 2013-04-02 16:54:02
Message-ID: CALxYTP5-BBR+KP7q92PfWfA8UGCPRMKFpFaSg_UznBwPkpO9ww@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-sql

On Tue, Apr 2, 2013 at 10:53 AM, David Guyot <
david(dot)guyot(at)europecamions-interactive(dot)com> wrote:

> Mister,
>
> Thank you for your answer. I had in mind that this line was for the
> initial start of the standby; should I just comment it before promoting the
> standby, or is this line useless for the day-to-day standby service?
>

This might help (just stop before the cascade stuff)
http://bartek.im/blog/2012/12/04/postgresql-92-streaming-primer.html

--
Douglas J Hunley (doug(dot)hunley(at)gmail(dot)com)
Twitter: @hunleyd Web:
douglasjhunley.com
G+: http://goo.gl/sajR3

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bert 2013-04-02 17:34:02 slave restarts with kill -9 coming from somewhere, or nowhere
Previous Message Douglas J Hunley 2013-04-02 16:51:48 Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes?

Browse pgsql-sql by date

  From Date Subject
Next Message Kaleeswaran Velu 2013-04-04 04:08:26 Postgres trigger issue with update statement in it.
Previous Message Douglas J Hunley 2013-04-02 16:51:48 Re: Hot standby with streaming replication under PgSQL 9.1.x : failover when master crashes?