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: How to make replica and use it when master is down ?
Date: 2011-10-12 08:31:30
Message-ID: 2dc63c0de84ede27e78e5cd01c13528b@stz-bg.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sarma Chavali 2011-10-12 08:50:19 Conceptual Architecture
Previous Message Andreas Forø Tollefsen 2011-10-12 07:52:58 Re: [postgis-users] Query slow down, never completes