Re: HOW-TO migrate database

Hello

I use the "-d" switch and data format is correctly exported from database.
There's no problem to import table schemes and data to new 7.1.2

Marian Sabo

"Tom Lane" <tgl@sss.pgh.pa.us> wrote in message
news:25373.995388342@sss.pgh.pa.us...
> "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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster