Francisco Reyes wrote:
> On 4:05 pm 07/21/08 Jack Orenstein <jack.orenstein@hds.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