pg_dump fails when a table is in ACCESS SHARE MODE

Поиск
Список
Период
Сортировка
От Viral Shah
Тема pg_dump fails when a table is in ACCESS SHARE MODE
Дата
Msg-id CAEVFvu0aY4qgxVtMJvPTqty0pmL-jqsbsY9DkmA8REDbQtwKcw@mail.gmail.com
обсуждение исходный текст
Ответы Re: pg_dump fails when a table is in ACCESS SHARE MODE
Список pgsql-sql
Hello All,

I am facing some problems while taking logical backup of my database using pg_dump. We have set up our infrastructure such that the logical backups are taken on our DR. Our intention here is to avoid substantial load on our primary server. We also pause and play wal files using pg_wal_replay_pause and pg_wal_replay_resume before and after pg_dump. However, at the time of pausing the wal replay, if there is a table under ACCESS SHARE MODE, the pg_dump cannot complete the backup. 

Can anyone suggest any better solution to take a logical backup using pg_dump where the table lock doesn't result in failure of the logical backup?

PS: we are using PostgreSQL 10.12

Thanks, 
Viral Shah
Data Analyst, Nodal Exchange LLC
viralshah009@gmail.com
(240) 645 7548

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

Предыдущее
От: "Mike Sofen"
Дата:
Сообщение: RE: SQL schema and query optimisation for fast cross-table query execution
Следующее
От: Rene Romero Benavides
Дата:
Сообщение: Re: pg_dump fails when a table is in ACCESS SHARE MODE