Re: migrate data 6.5.3 -> 8.3.1 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: migrate data 6.5.3 -> 8.3.1
Date
Msg-id 20665.1218809691@sss.pgh.pa.us
Whole thread Raw
In response to Re: migrate data 6.5.3 -> 8.3.1  (alexander lunyov <lan@zato.ru>)
Responses Re: migrate data 6.5.3 -> 8.3.1  (alexander lunyov <lan@zato.ru>)
Re: migrate data 6.5.3 -> 8.3.1  (alexander lunyov <lan@zato.ru>)
List pgsql-hackers
alexander lunyov <lan@zato.ru> writes:
> I want to try new pg_dump to connect to old server, but i can't - old
> postgres doesn't listening to network socket.

It won't work anyway: modern versions of pg_dump are only designed to
work with servers back to 7.0.  I see from the rest of the thread that
you tried to bludgeon it into submission, but I'd very strongly
recommend that you abandon that approach and use 6.5's pg_dump.

A further suggestion is that you use -d or even -D option on the dump.
I think there have been some corner-case changes in COPY data format
since 6.5 days; which might or might not bite you, but why take the
chance ...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: So what about XSLT?
Next
From: Andrew Dunstan
Date:
Subject: Re: So what about XSLT?