[ADMIN] Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton?

2008-02-18 Thread libra dba
Hello all, I am new to postgresql. i am working on the PITR replication system. I have successfully implemented the standby database. I have tested the log shipment and the recovery process on the standby. everything is workign fine. Please guide me how to bring the standby database in open mode

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

2008-02-19 Thread libra dba
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: ---

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

2008-02-21 Thread libra dba
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. &

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

2008-02-27 Thread libra dba
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 <[EMAIL PROTECTED]>

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

2008-02-28 Thread libra dba
ed, Feb 27, 2008 at 4:05 PM, salman <[EMAIL PROTECTED]> wrote: > > > libra dba wrote: > > 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 ma

[ADMIN] using warm standby with drbd???

2008-03-04 Thread libra dba
Hi All! I have configured the warm standby using WAL FILES and DRBD. The wal files are generated as server A. I am using DRBD to replicate these wal files between server A and server B. The DRBD service is running as Primary on Server A and secondary on Server B. The wal_files are written to the s