Thread: CORRECTION to msg 'loading same instance of dump to two different servers simultaneously'
CORRECTION to msg 'loading same instance of dump to two different servers simultaneously'
From
Susan Russo
Date:
SORRY -
these are the commands (i.e. pgserver-A and pgserver-B)
======
Hi -
I'm wondering if anyone has had success doing a simultaneous
load of one Pg dump to two different servers? The load command
is actually run from two different workstations, but reading the
same pgdump-file.
We use this command from the command line (Solaris-10 OS):
uncompress -c pgdump-filename.Z | psql -h pgserver-A pg-dbname
and, likewise wonder if we can run the same command on another
workstation, but reading the SAME 'pgdump-filename.Z'
to load onto ANOTHER server ('pgserver-B'), i.e.:
uncompress -c pgdump-filename.Z | psql -h pgserver-B pg-dbname
=====
S
Re: [PERFORM] CORRECTION to msg 'loading same instance of dump to two different servers simultaneously'
From
"D'Arcy J.M. Cain"
Date:
No need to crosspost. I removed -performance from the Cc. On Fri, 22 Feb 2008 13:37:43 -0500 (EST) Susan Russo <russo@morgan.harvard.edu> wrote: > I'm wondering if anyone has had success doing a simultaneous > load of one Pg dump to two different servers? The load command > is actually run from two different workstations, but reading the > same pgdump-file. Do you have any reason to doubt that this would work? Have you tried it? As long as the targets are different I don't see any problem. -- D'Arcy J.M. Cain <darcy@druid.net> | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.