Re: How to make replica and use it when master is down ?

From: Condor <condor(at)stz-bg(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to make replica and use it when master is down ?
Date: 2011-10-15 07:36:53
Message-ID: 912888229304c618a737cac00d2e2626@stz-bg.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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]
>
> 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(at)postgresql(dot)org [1])
>> To make
changes to your subscription:
>>
http://www.postgresql.org/mailpref/pgsql-general [2]

Yеs I see this,
but I actually want user comments and problems that can arise.

--

Regards,
Condor

Links:
------
[1]
mailto:pgsql-general(at)postgresql(dot)org
[2]
http://www.postgresql.org/mailpref/pgsql-general
[3]
http://www.postgresql.org/docs/9.0/interactive/high-availability.html
[4]
mailto:condor(at)stz-bg(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Robert Haas 2011-10-15 10:51:35 Re: [HACKERS] register creation date of table
Previous Message Jay Levitt 2011-10-15 04:16:38 find_psql_error