pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: salman <salmanb@quietcaresystems.com>
To: libra dba <libra.dba@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton?
Date: Tue, 19 Feb 2008 10:56:55 -0500
Message-ID: <47BAFC47.4060902@quietcaresystems.com> (raw)
In-Reply-To: <9abe84da0802190623o2a24f2a5u9a44299fd634618e@mail.gmail.com>
References: <84D57263D486374587DA0820E60A2CC601B07E23@srit_mail.renaissance-it.com>
	<1203409158.16770.821.camel@ebony.site>
	<9abe84da0802190623o2a24f2a5u9a44299fd634618e@mail.gmail.com>



libra dba wrote:
> Hello all,
> 
> Thanks for your response. The example shown by Charles Duffy, is quite
> impressive. Actually i built my replication based on this.
> 
> But, i want to test the failover. In the example shown by Charles, mentions
> 'a trigger file' as it says:
> -------------------------------------------------------------------------------
> *touch ~/pg82demo/trigger*
> **
> *This should immediately cause the slave to finish processing archived
> segments, exit recovery mode, and come up ready for use.
> *
> -------------------------------------------------------------------------------
> what shold be the content of the trigger file. How do we cause the slave to
> finish the processing of the archived segments, exit the recovery mode and
> come up ready for use???
> 
> Please help in the the FAILOVER of the primary and promoting the slave to
> the primary mode.
> 

It's an empty file -- doesn't have to have anything in it. The script 
simply checks to see if the file exists, and if it does, the recovery 
loop is stopped.

-salman



view thread (11+ messages)  latest in thread

Message-ID: <47BAFC47.4060902@quietcaresystems.com>
Permalink:  ../47BAFC47.4060902@quietcaresystems.com/
Also on:    postgresql.org/message-id/47BAFC47.4060902@quietcaresystems.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: salmanb@quietcaresystems.com, libra.dba@gmail.com
  Subject: Re: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton?
  In-Reply-To: <47BAFC47.4060902@quietcaresystems.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox