Postgres Pro
Downloads
Home   >   mailing lists

Re: How to make replica and use it when master is down ? - Mailing list pgsql-general

From Mark Keisler
Subject Re: How to make replica and use it when master is down ?
Date
Msg-id CAGNWxWpnvgq9To1mxkQ+AMRkO-Q9AY95dz60k9Bn9cmOUE=1Cw@mail.gmail.com
Whole thread Raw
In response to How to make replica and use it when master is down?  (Condor <condor@stz-bg.com>)
Responses Re: How to make replica and use it when master is down ?  (Condor <condor@stz-bg.com>)
List pgsql-general
Tree view
It is possible.  See http://www.postgresql.org/docs/9.0/interactive/high-availability.html


On Wed, Oct 12, 2011 at 3:31 AM, Condor <condor@stz-bg.com> wrote:
Hello everyone,
from a few days I want to ask how to make replica server of my database and when spontaneously my master server going down due to loosing power or has been offline more then 5 min, replica server to become
master server and accept all querys to database like select, insert, update and so on and when original master server become online to sync his db or just to stay slave / replica server until one of
the servers does not going down ?

Well, I don't know if this is possibly.



--
Regards,
Condor

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Steve Clark
Date:
Subject: Re: Ideas for query
Next
From: Mark Keisler
Date:
Subject: Re: Monitoring Replication