: 世界上功能最强大的开源数据库...

cctvmtv	pg11.7用pg_dump备份报错 ... ... 2022-03-15 08:48:29+08...1楼
	pg11.7由于数据量的增大，在主数据库备份大数据量的库时出现如下错误： pg_dump: FATAL: terminating connection due to conflict with recovery DETAIL: User query might have needed to see row versions that must be removed. HINT: In a moment you should be able to reconnect to the database and repeat your command. pg_dump: [archiver (db)] query failed: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. pg_dump: [archiver (db)] query was: FETCH 100 FROM _pg_dump_cursor 之前主库备份一直可以的，最近不知道为什么在主库备份出现这种错误，我是ssh连接进主数据库服务器备份的。备份命令如下： pg_dump -n fishing -U postgres --column-inserts fishery>/home/backup/fishery/fishing/fishing-`date +%Y%m%d`.sql
	我的签名：