Re: Default maximum time replication between master and slave databases

Поиск
Список
Период
Сортировка
От Scott Ribe
Тема Re: Default maximum time replication between master and slave databases
Дата
Msg-id AF02885C-89DF-4C6F-A060-494CE3F80B07@elevated-dev.com
обсуждение исходный текст
Ответ на Default maximum time replication between master and slave databases  (Alberto Olivares <alberto.olivares@snowflakesoftware.com>)
Ответы Re: Default maximum time replication between master and slave databases
Список pgsql-admin
On Jul 10, 2015, at 6:54 AM, Alberto Olivares <alberto.olivares@snowflakesoftware.com> wrote:
>
> SELECT EXTRACT (epoch from now() - pg_last_xact_replay_timestamp());
>
> The maximum result is 60 seconds then the value goes to 0 and start again. I would like to modify this value to
maximum30 seconds. 
>
> I have tried to change different parameters on the  postgresql.conf in both databases but I have not find the
solution.

WAL shipping or streaming?

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
https://www.linkedin.com/in/scottribe/
(303) 722-0567 voice







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

Предыдущее
От: "michael@sqlexec.com"
Дата:
Сообщение: Re: Automatic restore corruption problem
Следующее
От: Alberto Olivares
Дата:
Сообщение: Re: Default maximum time replication between master and slave databases