Logical replication failed recovery

Поиск
Список
Период
Сортировка
От Lou Tseng
Тема Logical replication failed recovery
Дата
Msg-id DM6PR11MB2939FF65103200D9F8BA88BCC4530@DM6PR11MB2939.namprd11.prod.outlook.com
обсуждение исходный текст
Ответы Re: Logical replication failed recovery
Re: Logical replication failed recovery
Список pgsql-general
Hi folks,

Is there a good tutorial to recover from logical replication out of sync?  We ran into this error stating WAL has been removed and now replica is out of sync.  Also, is there a way to increase the number of WAL kept on the master?

Thanks!

2019-04-07 12:28:37.180 UTC [22292] ERROR:  could not receive data from WAL stream: ERROR:  requested WAL segment 0000000100005208000000EB has already been removed

2019-04-07 12:28:37.182 UTC [114186] LOG:  worker process: logical replication worker for subscription 8907992 (PID 22292) exited with exit code 1


Lou Tseng

ltseng@advancedpricing.com
Advanced Medical Pricing Solutions
35 Technology Parkway South, Suite. 100
Peachtree Corners, GA 30092

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

Предыдущее
От: Joe Conway
Дата:
Сообщение: Re: Query much slower on 9.6.5 than on 9.3.5
Следующее
От: Pavan Teja
Дата:
Сообщение: Re: Logical replication failed recovery