Search Postgresql Archives

Re: How to verify pg_dump files

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 11/07/2012 11:56 AM, Igor Neyman wrote:
The only 100% fool-proof test would be to restore from your backup files.

Regards,
Igor Neyman
Our internal process is to back up production databases regularly, and then use the backups offsite to populate copies of databases for developer use. This allows us to test with real data, identifying real world bugs that would not appear with often-limited, manually created, "sample data", as well as verify our backups on a regular, daily basis.

I'd strongly recommend something similar if it works for you.

-Ben


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux