Additionally there are known issues dumping and restoring from 7.3 -> 7.4 if you use the default copy command. Use the pg_dump --inserts option.
I would still tar the directory just in case you *have* to fall back to 7.3 for some reason (Better safe than sorry )
Dave
Richard Huxton wrote:
[EMAIL PROTECTED] wrote:
I would like to upgrade both OS kernel and PGsql version , so in my opinion the
best way to handle it is to *backup* the data in .tar
Just remember if you're going from 7.3.2 => 7.4.x or 8.0 then you'll need to use pg_dump not just tar up the directories. If you do use tar, remember to backup *all* the directories.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
-- Dave Cramer http://www.postgresintl.com 519 939 0336 ICQ#14675561
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org