Postgres Pro
Downloads
Home   >   mailing lists

Re: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton? - Mailing list pgsql-admin

From Praveen Kumar \(TUV\)
Subject Re: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton?
Date
Msg-id 84D57263D486374587DA0820E60A2CC601B07E23@srit_mail.renaissance-it.com
Whole thread Raw
In response to Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton?  ("libra dba" <libra.dba@gmail.com>)
Responses Re: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton?  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-admin
Tree view

 

Hello ,

Go through this below mentioned link

 

http://archives.postgresql.org/sydpug/2006-10/msg00001.php

From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of libra dba
Sent: Friday, February 15, 2008 4:11 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton?

 

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 (failover). Also it would be great if you could provide a sample trigger file.

 

thanks

Attachment

pgsql-admin by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Update 8.2 to 8.3
Next
From: Simon Riggs
Date:
Subject: Re: Failover of the Primary database and starting the standby database in Postgresql in PITR configuraiton?