Re: pgsql 7.0 recovery to 7.4

Marcin Gil <marcin.gil@audax.com.pl> writes:
> For the future:
> - how should I dump my databases to omit such problems?

pg_dump or pg_dumpall

> - is pg_dump format compatible, ie will loading 7.0 version into 7.4 go
>    without a glitch?

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