INT 21h

Hi, I am Vladimir Smagin, SysAdmin and Kaptain. Telegram Email / GIT / RSS / GPG

Postgresql logical backup failed, pg_dump said: PQgetResult() failed

№ 10947 В разделе Sysadmin от March 20th, 2020,
В подшивках: , ,

You made streaming backups and restoring with walg and now trying to make logical backups.

But some shit ruined your plans:

pg_dump: Dumping the contents of table "<table>" failed: PQgetResult() failed.

Many sites suggests to enable hot_standby_feedback in postgresql.conf, but actually you need also increase max_standby_archive_delay and max_standby_streaming_delay. I set 1 hour.

Нет комментариев »

Leave a Reply

Your email address will not be published. Required fields are marked *

CAPTCHA

*

Яндекс.Метрика

Fortune cookie: Ever notice that the women who are against abortion are the ones you wouldn't want to fuck in the first place? -- George Carlin