I have an Azure Postgres flexible server running and need to take a backup of the database in it
Following the directions in 9.1.4 of The Postgres documentation here
I crafted the below pg-dump command.
pg_dump -b -Z0 -F t --host=hidden --username=hidden --dbname=temp --file=backup.tar
It runs for several hours before failing with the below output
pg_dump: error: error reading large object 350828: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
Any help figuring this out would be greatly appreciated
2
Answers
The comment about 'memory' from Laurenz helped me out. Temporarily increasing the memory and running the command helped.
I use Azure Pg services too.
Try to use this command:
This works from my side.