Re: migrate data 6.5.3 -> 8.3.1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: alexander lunyov <lan(at)zato(dot)ru>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: migrate data 6.5.3 -> 8.3.1
Date: 2008-08-15 14:14:51
Message-ID: 20665.1218809691@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

alexander lunyov <lan(at)zato(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2008-08-15 14:22:29 Re: So what about XSLT?
Previous Message Tom Lane 2008-08-15 14:05:24 Re: So what about XSLT?