Re: PostgreSQL 9.0 and asynchronous replication through VPN

Поиск
Список
Период
Сортировка
От John DeSoi
Тема Re: PostgreSQL 9.0 and asynchronous replication through VPN
Дата
Msg-id 4586E78C-7560-441D-B706-346E06CE0C2B@pgedit.com
обсуждение исходный текст
Ответ на PostgreSQL 9.0 and asynchronous replication through VPN  (Edson Richter <richter@simkorp.com.br>)
Ответы Re: PostgreSQL 9.0 and asynchronous replication through VPN  (Edson Richter <richter@simkorp.com.br>)
Список 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
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.

John DeSoi, Ph.D.


В списке pgsql-general по дате отправления:

Предыдущее
От: Eduardo Morras
Дата:
Сообщение: Re: odbc_fdw
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: DDL & DML Logging doesn't work for calling functions