thank you all! On Feb 19, 2008 10:56 AM, salman <[EMAIL PROTECTED]> 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 >
