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
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