Question 215166 in PostgreSQL Question posted in
The official documentation can be found here.

Postgresql – pg_dump from Azure Postgres failing

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

Tags:

2

Answers


  1. Chosen as BEST ANSWER
    0

    The comment about 'memory' from Laurenz helped me out. Temporarily increasing the memory and running the command helped.

    Screenshot on used memory stats


  2. 0

    I use Azure Pg services too.
    Try to use this command:

    psql.exe -h 127.0.0.1 -U user -d database

    This works from my side.

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search