在仍有许多活动事务的同时执行pg_dump [英] Doing pg_dump while still many active transaction

问题描述

作为主题，当数据库中仍有许多活动事务时，备份文件将如何处理。

As subjects, what will happen to the backup file while there is still many active transaction in the database. Does it export realtime or just partially backups ?

预先感谢。

推荐答案

pg_dump在可序列化的事务中运行，因此它可以看到包括系统目录在内的数据库的一致快照。

pg_dump runs in a serializable transaction, so it sees a consistent snapshot of the database including system catalogs.

但是有可能出现缓存查找失败错误如果在转储开始时有人执行DDL更改。这种事情的时间窗口不是很大，但是有可能发生。请参阅： http://archives.postgresql.org/pgsql-bugs/2010 -02 / msg00187.php

However it is possible to get 'cache lookup failed' error if someone performs DDL changes while a dump is starting. The time window for this sort of thing isn't very large, but it can happen. See: http://archives.postgresql.org/pgsql-bugs/2010-02/msg00187.php

这篇关于在仍有许多活动事务的同时执行pg_dump的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！