Hi!
I've just suffered a serious disk meltdown. Successfully I've got
all the files from pgsql 7.0 backed up.
Now I have problem because 7.4 won't read them (obviuos).
Is there a way to upgrade those files to v7.4?
I've tried to compile v7.0 on my slack 9.1 but it won't.

I will not insinst nor be insolent but need help fast.
Thanks!
--
Marcin Gil :: marcin.gil (AT) audax (DOT) com.pl
OIS Audax Sp. z o.o., ul. Barlickiego 4, 97-200 Tomaszów Mazowiecki
tel (44) 7247530 w/22, 7244401 w/22 -- fax w/25

---------------------------(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

Marcin Gil <marcin.gil (AT) audax (DOT) com.pl> writes:
You mean a filesystem-level dump of the data directory? Sorry, the
only way to deal with that is to install 7.0.something and then make
a pg_dump or pg_dumpall dump.

I wouldn't be too surprised if it needs some minor tweaking for newer
Linuxen.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo (AT) postgresql (DOT) org

Tom Lane wrote:

a challenge

I'd rather install an old one - it's faster.

For the future:
- how should I dump my databases to omit such problems?
- is pg_dump format compatible, ie will loading 7.0 version into 7.4 go
without a glitch?

--
Marcin Gil :: marcin.gil (AT) audax (DOT) com.pl
OIS Audax Sp. z o.o., ul. Barlickiego 4, 97-200 Tomaszów Mazowiecki
tel (44) 7247530 w/22, 7244401 w/22 -- fax w/25

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Marcin Gil <marcin.gil (AT) audax (DOT) com.pl> writes:
pg_dump or pg_dumpall

Yes, it should. Actually the best practice for an upgrade is to run the
newer version's pg_dump against the older server, if you can. That way
you get the benefit of any pg_dump bug fixes in the newer version.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo (AT) postgresql (DOT) org)