Re: PostgreSQL 9.0 and asynchronous replication through VPN

From: Edson Richter <richter(at)simkorp(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL 9.0 and asynchronous replication through VPN
Date: 2011-11-30 16:41:52
Message-ID: 4ED65CD0.3000005@simkorp.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Em 30-11-2011 11:17, John DeSoi escreveu:
> On Nov 30, 2011, at 5:02 AM, Edson Richter wrote:
>
>> I assume that the OpenVPN got disconnected for a few seconds, and came back again.
>>
>> My question is: assuming I have enough wal segments on Master side, does the Slave get synchronized automatically after the connection is reestablished, or I'll need to restart Slave PostgreSQL to put it in sync again?
>>
>> If I restart Slave PostgreSQL, I get:
>
> Yes, it automatically catches up when the connection is working again. You should not have to restart the slave.
Thanks! Would be a nice improvement if when replication is restablished,
then a log message occur.

Regards,

Edson.
>
> John DeSoi, Ph.D.
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tomas Vondra 2011-11-30 16:43:05 Re: Strange problem with turning WAL archiving on
Previous Message BK 2011-11-30 16:23:35 Re: Strange problem with turning WAL archiving on