Re: HOW-TO migrate database

"Marian Sabo" <sabo@cps.sk> writes:
> I have a many databases on server "one" in postgres-6.5.2
> How can I copy my databases to a new server with new postgres vsersion
> (7.1.2) ?
> on first server I run : pg_dumpall -o > outputfile, but on new server
> pg_restore don't understand the data format.

pg_dumpall is the right approach, though I would not recommend using -o.

Possibly you will need to do a little bit of editing to cope with
changes from 6.5 to 7.1, although it surprises me to hear it.  What
problems are you seeing, exactly, when you try to load the dump script?

            regards, tom lane