英文:
pg_dump from Azure Postgres failing
问题
我有一个正在运行的Azure Postgres灵活服务器，并需要对其中的数据库进行备份。
按照Postgres文档1中第9.1.4部分的说明，我制作了以下pg-dump命令。
pg_dump -b -Z0 -F t --host=hidden --username=hidden --dbname=temp --file=backup.tar
它运行了几个小时后失败，并显示以下输出。
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.
任何有助于解决这个问题的帮助将不胜感激。
英文:
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
答案1
得分: 0
我也使用Azure Pg服务。
尝试使用这个命令：
psql.exe -h 127.0.0.1 -U user -d database
这在我的一侧有效。
英文:
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.
答案2
得分: 0
"Laurenz 的有关 'memory' 的评论对我有帮助。临时增加内存并运行该命令有所帮助。
英文:
The comment about 'memory' from Laurenz helped me out.
Temporarily increasing the memory and running the command helped.
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库，让每个人都能够通过互相帮助和分享经验来进步。
评论