Susan Russo wrote:
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
I don't think this is really a postgres question, but the fact you're on
a UNIX type of OS, you should have no problem doing this. uncompress
will simply open the file separately for each shell session.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
