Re: PostgreSQL 9.0 and asynchronous replication through VPN - Mailing list pgsql-general

From Edson Richter
Subject Re: PostgreSQL 9.0 and asynchronous replication through VPN
Date
Msg-id 4ED65CD0.3000005@simkorp.com.br
Whole thread Raw
In response to Re: PostgreSQL 9.0 and asynchronous replication through VPN  (John DeSoi <desoi@pgedit.com>)
Responses Re: PostgreSQL 9.0 and asynchronous replication through VPN
List 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
afterthe 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.
>
>

pgsql-general by date:

Previous
From: "Tomas Vondra"
Date:
Subject: Re: Strange problem with turning WAL archiving on
Next
From: Rodrigo Gonzalez
Date:
Subject: Re: Strange problem with turning WAL archiving on