From: | Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
---|---|
To: | Anupama Ramaswamy <anumr_0123(at)yahoo(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: streaming replication + wal shipping |
Date: | 2014-04-15 10:09:51 |
Message-ID: | A737B7A37273E048B164557ADEF4A58B17CF0688@ntex2010i.host.magwien.gv.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> Anupama Ramaswamy wrote:
>>> I would like to setup a 2 servers with streaming replication, one master and another hot standby.
>>> I want to use the standby for read-only queries. So I want the replication lag to be as small as
>>> possible.
>>> So I choose streaming replication over WAL shipping.
>>>
>>> When the master fails, I want the standby to take over as master. So I would like minimal data loss,
>>> if there is a streaming replication delay.
>>>
>>> Is it possible to setup such a way that under normal conditions the standby by replicating using
>>> streaming replication and on failover, it uses the WAL archive for syncing up with the transactions.
>>> Of course the WAL will be available on a shared storage volume. If this is possible, what exactly do
>>> I need in my configuration files - postgresql.conf, recovery.conf ?
>>
>> Most of this will happen automatically - WAL archives are used if recovery
>> falls behind.
> So are you saying that if I setup the following in my recovery.conf
> restore_command =.....
>
> It will it be used only when the streaming replication falls behind more than ( wal_keep_segments ) or
> replication stream is not available (master goes down) ?
Yes.
Yours,
Laurenz Albe
From | Date | Subject | |
---|---|---|---|
Next Message | Willy-Bas Loos | 2014-04-15 11:08:24 | [GENARAL] round() bug? |
Previous Message | Rémi Cura | 2014-04-15 09:25:37 | Re: efficient way to do "fuzzy" join |