Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL 9.0 and asynchronous replication through VPN

From: John DeSoi <desoi(at)pgedit(dot)com>
To: Edson Richter <richter(at)simkorp(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL 9.0 and asynchronous replication through VPN
Date: 2011-11-30 13:17:34
Message-ID: 4586E78C-7560-441D-B706-346E06CE0C2B@pgedit.com (view raw or flat)
Thread:
Lists: pgsql-general
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.

John DeSoi, Ph.D.


In response to

Responses

pgsql-general by date

Next:From: Albe LaurenzDate: 2011-11-30 13:25:54
Subject: Re: DDL & DML Logging doesn't work for calling functions
Previous:From: Eduardo MorrasDate: 2011-11-30 11:33:57
Subject: Re: odbc_fdw

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group