pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedloading same instance of dump to two different servers simultaneously?
3+ messages / 2 participants
[nested] [flat]
* loading same instance of dump to two different servers simultaneously?
@ 2008-02-22 18:34 Susan Russo <russo@morgan.harvard.edu>
0 siblings, 2 replies; 3+ messages in thread
From: Susan Russo @ 2008-02-22 18:34 UTC (permalink / raw)
To: pgsql-admin@postgresql.org; pgsql-performance; +Cc: harvsys@morgan.harvard.edu; russo@morgan.harvard.edu
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: loading same instance of dump to two different servers simultaneously?
@ 2008-02-22 19:26 Geoffrey <lists@serioustechnology.com>
parent: Susan Russo <russo@morgan.harvard.edu>
1 sibling, 0 replies; 3+ messages in thread
From: Geoffrey @ 2008-02-22 19:26 UTC (permalink / raw)
To: pgsql-admin@postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: loading same instance of dump to two different servers simultaneously?
@ 2008-02-22 19:27 Geoffrey <lists@serioustechnology.com>
parent: Susan Russo <russo@morgan.harvard.edu>
1 sibling, 0 replies; 3+ messages in thread
From: Geoffrey @ 2008-02-22 19:27 UTC (permalink / raw)
To: pgsql-admin@postgresql.org
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'm assuming the above line should have been:
uncompress -c pgdump-filename.Z | psql -h pgserver-B pg-dbname
^
^
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-02-22 19:27 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-02-22 18:34 loading same instance of dump to two different servers simultaneously? Susan Russo <russo@morgan.harvard.edu>
2008-02-22 19:26 ` Geoffrey <lists@serioustechnology.com>
2008-02-22 19:27 ` Geoffrey <lists@serioustechnology.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox