阅读背景:

有办法检查使用pg_dump的postgres备份(或恢复的数据库)的完整性吗?

来源:互联网 

Hi i have a pretty big database running on Postgres 9.3. I backup it up using pg_dump with compression. I am worried that these backups may be corrupted or that i won't be able to restore it properly (using pg_restore), or that restored database is could be corrupted. The database I backup is in constant use so it's pretty hard (if not impossible) to check if restored database is working correctly by comparing rows (and to be honest i don't think that such test would give a result that's meaningful). Is there any way to check integrity of dump file or a restored database ? I read that postgres 9.3 supports checksumming db files, but i don't see how that would help my case. Hi i have a pretty big database running on Post




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: