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