Re: COPY between 7.4.x and 8.3.x

Francisco Reyes wrote:
> On 4:05 pm 07/21/08 Jack Orenstein <jack(dot)orenstein(at)hds(dot)com> wrote:

>> What if we do a binary copy instead?
> What do you mean by a binary copy?
> pg_dump -Fc?

No, I mean changing this:

psql -h $SOURCE_HOST ... -c "copy $SOURCE_SCHEMA.$SOURCE_TABLE to stdout" |\
psql ... -c "copy $TARGET_SCHEMA.$TARGET_TABLE from stdin"

to this:

psql -h $SOURCE_HOST ... -c "copy binary $SOURCE_SCHEMA.$SOURCE_TABLE to
stdout" |\
psql ... -c "copy binary $TARGET_SCHEMA.$TARGET_TABLE from stdin"

> Why will you keep copying data back and forth?
> Not possible to setup a new 8.3, migrate to it and then upgrade the other
> 7.4 machine to 8.3?

We're migrating a cluster from 7.4 to 8.3. To maintain availability, we need the
7.4 and 8.3 databases up at the same time. We're copying data across versions
for this reason.

Jack