Re: PostGreSQL Replication and question on maintenance

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: PostGreSQL Replication and question on maintenance
Дата
Msg-id CAMkU=1w3t-PO8OoBnZRVF4Y9v+MBO-WWfgL-E9LVxNKedcRdow@mail.gmail.com
обсуждение исходный текст
Ответ на PostGreSQL Replication and question on maintenance  (github kran <githubkran@gmail.com>)
Ответы Re: PostGreSQL Replication and question on maintenance  (github kran <githubkran@gmail.com>)
Список pgsql-general
On Thu, Nov 14, 2019 at 12:23 PM github kran <githubkran@gmail.com> wrote:

 

Problem what we have right now.

When the migration activity runs(weekly) from past 2 times , we saw the cluster read replica instance has restarted as it fallen behind the master(writer instance).


I can't figure out what your setup is here.  You must be using logical replication (not physical) or you wouldn't be able to write to the replica at all.  But if you are using logical replication, why do you also need these weekly jobs?  Why isn't logical replication taking care of it?


 

Everything

after that worked seamlessly but we want to avoid the replica getting restarted. To avoid from restart we started doing smaller binary files and copy those files to the cluster-2


Who restarted it?  I am not aware of any case where the replica responds to falling behind by restarting itself.  With physical replication, it can start cancelling queries, but you don't seem to be using physical replication.

Cheers,

Jeff

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

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Function performance degrades after repeated execution
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: Weird ranking results with ts_rank