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.