这是一个与此处讨论的问题类似的问题：

This is a similar problem as discussed here:

可以回滚交易吗？已经承诺？ （数据丢失）

基本上，从备份中还原。如果不能，则可能可以使用 pg_dirtyread 恢复。

Basically, restore from backup. If you can't, you might be able to recover with pg_dirtyread.

如果您没有备份，请停止整个服务器，获取驱动器的磁盘映像，然后联系$ lots数据恢复专家。

If you don't have backups, stop the whole server, take a disk image of the drive, and contact a $lots data recovery expert.