| 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: | loading same instance of dump to two different servers simultaneously? |
| Date: | 2008-02-22 18:34:43 |
| Message-ID: | 200802221834.m1MIYhvA001607@larrys.harvard.edu |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-performance |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Susan Russo | 2008-02-22 18:37:43 | CORRECTION to msg 'loading same instance of dump to two different servers simultaneously' |
| Previous Message | Alvaro Herrera | 2008-02-22 18:27:24 | Re: Stray autovacuum daemon |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Susan Russo | 2008-02-22 18:37:43 | CORRECTION to msg 'loading same instance of dump to two different servers simultaneously' |
| Previous Message | Matthew | 2008-02-22 15:49:34 | Re: store A LOT of 3-tuples for comparisons |