Long term database archival
От | Karl O. Pinc |
---|---|
Тема | Long term database archival |
Дата | |
Msg-id | 1152212276l.4335l.2l@mofo обсуждение исходный текст |
Ответы |
Re: Long term database archival
Re: Long term database archival Re: Long term database archival |
Список | pgsql-general |
Hi, What is the best pg_dump format for long-term database archival? That is, what format is most likely to be able to be restored into a future PostgreSQL cluster. Mostly, we're interested in dumps done with --data-only, and have preferred the default (-F c) format. But this form is somewhat more opaque than a plain text SQL dump, which is bound to be supported forever "out of the box". Should we want to restore a 20 year old backup nobody's going to want to be messing around with decoding a "custom" format dump if it does not just load all by itself. Is the answer different if we're dumping the schema as well as the data? Thanks. Karl <kop@meme.com> Free Software: "You don't pay back, you pay forward." -- Robert A. Heinlein
В списке pgsql-general по дате отправления: