Re: moving a database.

LWATCDR <lwatcdr(at)gmail(dot)com> writes:
> I have an old postgres 7.1 data base that I must migrate to a new
> server running 8.2.6.
> The problem is everything I have tried has failed. The database has
> blobs in it but other than that it is pretty simple.
> So my question is what command line should I use to try and migrate
> this old database to the new server?

You want to pg_dump (or pg_dumpall, but pg_dump'ing each database
would give you a bit more control) and load the resulting script
into the new server.

If possible, use the 8.2 pg_dump to do this, as it's a lot more
featureful than what came with 7.1 --- in particular it will
handle blobs better.

I have a vague recollection that there are some corner cases that
changed in the COPY data format since 7.1. If you are having
trouble with getting the data reloaded, try using the -d option
to pg_dump.

regards, tom lane