Re: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



continuing with the postgres replication using WARM STANDBY, what happens to the wal_files which keeps on generating on the primary?
 
Do we have to manually remove them or they are removed automatically, once they have been recovered on the warm standby?
 
Also a quick question, do we have to have a NFS for the wal_files, which will be mounted on both the servers, or we can have folders on each server and configure DRBD between them, so that whatever happens on one is copied automatically on to the other.
 
Thanks!

On Wed, Feb 20, 2008 at 11:49 AM, libra dba <libra.dba@xxxxxxxxx> wrote:
thank you all!


On Feb 19, 2008 10:56 AM, salman <salmanb@xxxxxxxxxxxxxxxxxxxx> 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



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux