How to make replica and use it when master is down ?
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
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:
Show quoted text
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>
On 13.10.2011 22:47, Mark Keisler wrote:
It is possible. See
http://www.postgresql.org/docs/9.0/interactive/high-availability.html
[3]: http://www.postgresql.org/docs/9.0/interactive/high-availability.html
On Wed, Oct 12, 2011 at 3:31 AM, Condor 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 [1]mailto:pgsql-general@postgresql.org)
To make
changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general [2]http://www.postgresql.org/mailpref/pgsql-general
Yеs I see this,
but I actually want user comments and problems that can arise.
--
Regards,
Condor
Links:
------
[1]: mailto:pgsql-general@postgresql.org
mailto:pgsql-general@postgresql.org
[2]: http://www.postgresql.org/mailpref/pgsql-general
http://www.postgresql.org/mailpref/pgsql-general
[3]: http://www.postgresql.org/docs/9.0/interactive/high-availability.html
http://www.postgresql.org/docs/9.0/interactive/high-availability.html
[4]: mailto:condor@stz-bg.com
mailto:condor@stz-bg.com