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 <con...@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<http://www.postgresql.org/mailpref/pgsql-general> >
