From: libra dba <libra.dba@gmail.com>
To: salman <salmanb@quietcaresystems.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton?
Date: Wed, 20 Feb 2008 11:49:18 -0500
Message-ID: <9abe84da0802200849w1f462558n270f4320a7465b6c@mail.gmail.com> (raw)
In-Reply-To: <47BAFC47.4060902@quietcaresystems.com>
References: <84D57263D486374587DA0820E60A2CC601B07E23@srit_mail.renaissance-it.com>
<1203409158.16770.821.camel@ebony.site>
<9abe84da0802190623o2a24f2a5u9a44299fd634618e@mail.gmail.com>
<47BAFC47.4060902@quietcaresystems.com>
thank you all!
On Feb 19, 2008 10:56 AM, salman <salmanb@quietcaresystems.com> wrote:
>
>
> 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: libra.dba@gmail.com, salmanb@quietcaresystems.com
Subject: Re: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton?
In-Reply-To: <9abe84da0802200849w1f462558n270f4320a7465b6c@mail.gmail.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