If one wanted to dump some postgres databases for long term
archival storage (maybe decades), what's the recommended
dump format? Is the tar or plain text preferred, or is
there some other approach (xml? csv?) I should be looking
at instead?
Or should we just leave these in some postgres
Ron Mayer [EMAIL PROTECTED] writes:
If one wanted to dump some postgres databases for long term
archival storage (maybe decades), what's the recommended
dump format?
Plain text pg_dump output, without question. Not only is it the most
likely to load without problems, but if necessary you
Ron Mayer wrote:
If one wanted to dump some postgres databases for long term
archival storage (maybe decades), what's the recommended
dump format? Is the tar or plain text preferred, or is
there some other approach (xml? csv?) I should be looking
at instead?
Or should we just leave these in
On 14/03/2008, brian [EMAIL PROTECTED] wrote:
The version you dump it from is unlikely to be difficult to find ten
years from now. I'd just make sure to append the pg version to the
archive so it's obvious to any future data archaeologists what's needed
to breathe life back into it.
Let me