| From: | Susan Russo <russo(at)morgan(dot)harvard(dot)edu> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org, pgsql-performance(at)postgresql(dot)org |
| Cc: | harvsys(at)morgan(dot)harvard(dot)edu, russo(at)morgan(dot)harvard(dot)edu |
| Subject: | CORRECTION to msg 'loading same instance of dump to two different servers simultaneously' |
| Date: | 2008-02-22 18:37:43 |
| Message-ID: | 200802221837.m1MIbhZS001801@larrys.harvard.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | D'Arcy J.M. Cain | 2008-02-22 19:18:03 | Re: [PERFORM] CORRECTION to msg 'loading same instance of dump to two different servers simultaneously' |
| Previous Message | Susan Russo | 2008-02-22 18:34:43 | loading same instance of dump to two different servers simultaneously? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | D'Arcy J.M. Cain | 2008-02-22 19:18:03 | Re: [PERFORM] CORRECTION to msg 'loading same instance of dump to two different servers simultaneously' |
| Previous Message | Susan Russo | 2008-02-22 18:34:43 | loading same instance of dump to two different servers simultaneously? |