Re: [BUGS] pg_dump's results have quite different size

Поиск
Список
Период
Сортировка
От Oleksandr Shulgin
Тема Re: [BUGS] pg_dump's results have quite different size
Дата
Msg-id CACACo5QRXyxKc6hm=mDNAQeS=bWa99u8odAGVv_mGEqNephPXQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [BUGS] pg_dump's results have quite different size  (Kaijiang Chen <chenkaijiang@gmail.com>)
Ответы Re: [BUGS] pg_dump's results have quite different size  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Список pgsql-bugs
On Wed, Dec 14, 2016 at 9:29 AM, Kaijiang Chen <chenkaijiang@gmail.com> wrote:
Yes. The pg_dump quits with the message:

pg_dump: Dumping the contents of table "data_histories" failed: PQgetResult() failed.
pg_dump: Error message from server: ERROR:  canceling statement due to conflict with recovery
DETAIL:  User query might have needed to see row versions that must be removed.
pg_dump: The command was: COPY public.data_histories (id, user_id, user_name, type, type_id, old_data, action, new_data, created_at, updated_at) TO stdout;

Ah, then it's just that your backup script is broken: it should have reported the error.

Please do not top-post.
--
Alex

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

Предыдущее
От: Kaijiang Chen
Дата:
Сообщение: Re: [BUGS] pg_dump's results have quite different size
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [BUGS] BUG #14466: can with recursive query add LOOPth variable?