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? |