Thread: 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

On Fri, 22 Feb 2008, Susan Russo 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.

Please don't cross-post.

I can't see any problems with doing that. You have two independent
workstations uncompressing the data, sending it over the network to two
independent servers. The only common points are the fileserver and the
network. Assuming both of those can keep up, you won't even have a
performance penalty.

Matthew

--
As you approach the airport, you see a sign saying "Beware - low
flying airplanes". There's not a lot you can do about that. Take
your hat off?                                  -- Michael Flanders