№ 10947 В разделе
Sysadmin
от March 20th, 2020,
В подшивках: Backups, Linux, PostgreSQL
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.
Fortune cookie: Is a tattoo real, like a curb or a battleship? Or are we suffering in Safeway?
Leave a Reply