Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 308BC2E00B3 for ; Tue, 19 Feb 2008 11:58:14 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 62926-01-3 for ; Tue, 19 Feb 2008 11:58:10 -0400 (AST) Received: from livingmail01.inetu.net (unknown [209.235.247.80]) by postgresql.org (Postfix) with ESMTP id BCEF12E0073 for ; Tue, 19 Feb 2008 11:56:57 -0400 (AST) Received: (qmail 1639 invoked by uid 0); 19 Feb 2008 15:56:57 -0000 Received: from unknown (HELO ?192.168.0.23?) (salmanb@quietcaresystems.com@127.0.0.1) by livingmail01.inetu.net with SMTP; 19 Feb 2008 15:56:57 -0000 Message-ID: <47BAFC47.4060902@quietcaresystems.com> Date: Tue, 19 Feb 2008 10:56:55 -0500 From: salman User-Agent: Mozilla-Thunderbird 2.0.0.6 (X11/20071009) MIME-Version: 1.0 To: libra dba CC: pgsql-admin@postgresql.org Subject: Re: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton? References: <84D57263D486374587DA0820E60A2CC601B07E23@srit_mail.renaissance-it.com> <1203409158.16770.821.camel@ebony.site> <9abe84da0802190623o2a24f2a5u9a44299fd634618e@mail.gmail.com> In-Reply-To: <9abe84da0802190623o2a24f2a5u9a44299fd634618e@mail.gmail.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200802/209 X-Sequence-Number: 28283 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