pg_dump: what is advantage with schema and data dumps?
| От | Anony Mous |
|---|---|
| Тема | pg_dump: what is advantage with schema and data dumps? |
| Дата | |
| Msg-id | 001301c4a259$e1604bb0$6a02a8c0@PETER обсуждение исходный текст |
| Ответы |
Re: pg_dump: what is advantage with schema and data dumps?
Re: pg_dump: what is advantage with schema and data dumps? |
| Список | pgsql-general |
Hi, I've seen in previous posts that recommended practice for database backup is to run the dump utility twice. Once for schema only and a second time for data only (I think). Up to know, I've only ever dumped both, and have never had a problem restoring into older/newer versions of postgres, nor with restoring into other commercial versions of postgres. This is a testament of the robustness of pg_dump! Of course, there are always a series of error messages at the start of each restore when duplicate/unknown template DB functions are recreated, but these have never prevented the core data from being properly copied into the database. Am I setting myself up for disaster with only a single dump as a backup? Much thanks, Peter
В списке pgsql-general по дате отправления: