Re: pgsql 7.0 recovery to 7.4

Tom Lane wrote:

> 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.
>
That's what I'm doing right now :( Getting RedHat 6.2 was quite
a challenge :)

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

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@audax.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