On 4:05 pm 07/21/08 Jack Orenstein <jack.orenstein@hds.com> wrote:
> We will now be adding 8.3.x databases to the mix, and will need to
> copy between 7.4.x and 8.3.x in both directions. The datatypes we use
I believe it should work.
Also, one feature I believe started in the 8.X line (8.2?), is the ability
to have a subquery in the copy command to refine what rows you are getting.
> What if we do a binary copy instead?
What do you mean by a binary copy?
pg_dump -Fc?
I think a plain pg_dump and copy will likely be more portable. Specially
going from 8.3 to 7.4.
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?