Обсуждение: CORRECTION to msg 'loading same instance of dump to two different servers simultaneously'

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

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.