Postgres Pro
Downloads
Home   >   mailing lists

loading same instance of dump to two different servers simultaneously? - Mailing list pgsql-performance

From Susan Russo
Subject loading same instance of dump to two different servers simultaneously?
Date
Msg-id 200802221834.m1MIYhvA001607@larrys.harvard.edu
Whole thread Raw
List pgsql-performance
Tree view 
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-A  pg-dbname

Thanks for any advice.
Susan Russo

pgsql-performance by date:

Previous
From: Susan Russo
Date:
Subject: CORRECTION to msg 'loading same instance of dump to two different servers simultaneously'
Next
From: "Kynn Jones"
Date:
Subject: Q on views and performance