pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCORRECTION to msg 'loading same instance of dump to two different servers simultaneously'
4+ messages / 3 participants
[nested] [flat]
* CORRECTION to msg 'loading same instance of dump to two different servers simultaneously'
@ 2008-02-22 18:37 Susan Russo <russo@morgan.harvard.edu>
2008-02-22 19:18 ` Re: [PERFORM] CORRECTION to msg 'loading same instance of dump to two different servers simultaneously' D'Arcy J.M. Cain <darcy@druid.net>
2008-02-25 13:11 ` Re: CORRECTION to msg 'loading same instance of dump to two different servers simultaneously' Matthew <matthew@flymine.org>
0 siblings, 2 replies; 4+ messages in thread
From: Susan Russo @ 2008-02-22 18:37 UTC (permalink / raw)
To: pgsql-admin; pgsql-performance@postgresql.org; +Cc: harvsys@morgan.harvard.edu; russo@morgan.harvard.edu
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [PERFORM] CORRECTION to msg 'loading same instance of dump to two different servers simultaneously'
2008-02-22 18:37 CORRECTION to msg 'loading same instance of dump to two different servers simultaneously' Susan Russo <russo@morgan.harvard.edu>
@ 2008-02-22 19:18 ` D'Arcy J.M. Cain <darcy@druid.net>
1 sibling, 0 replies; 4+ messages in thread
From: D'Arcy J.M. Cain @ 2008-02-22 19:18 UTC (permalink / raw)
To: Susan Russo <russo@morgan.harvard.edu>; +Cc: pgsql-admin
No need to crosspost. I removed -performance from the Cc.
On Fri, 22 Feb 2008 13:37:43 -0500 (EST)
Susan Russo <russo@morgan.harvard.edu> wrote:
> 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.
Do you have any reason to doubt that this would work? Have you tried
it? As long as the targets are different I don't see any problem.
--
D'Arcy J.M. Cain <darcy@druid.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: CORRECTION to msg 'loading same instance of dump to two different servers simultaneously'
2008-02-22 18:37 CORRECTION to msg 'loading same instance of dump to two different servers simultaneously' Susan Russo <russo@morgan.harvard.edu>
@ 2008-02-25 13:11 ` Matthew <matthew@flymine.org>
1 sibling, 0 replies; 4+ messages in thread
From: Matthew @ 2008-02-25 13:11 UTC (permalink / raw)
To: Susan Russo <russo@morgan.harvard.edu>; +Cc: pgsql-performance@postgresql.org; harvsys@morgan.harvard.edu
On Fri, 22 Feb 2008, Susan Russo wrote:
> 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.
Please don't cross-post.
I can't see any problems with doing that. You have two independent
workstations uncompressing the data, sending it over the network to two
independent servers. The only common points are the fileserver and the
network. Assuming both of those can keep up, you won't even have a
performance penalty.
Matthew
--
As you approach the airport, you see a sign saying "Beware - low
flying airplanes". There's not a lot you can do about that. Take
your hat off? -- Michael Flanders
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: [PERFORM] CORRECTION to msg 'loading same instance of dump to two different servers simultaneously'
@ 2008-02-22 19:24 Susan Russo <russo@morgan.harvard.edu>
0 siblings, 0 replies; 4+ messages in thread
From: Susan Russo @ 2008-02-22 19:24 UTC (permalink / raw)
To: darcy@druid.net; russo@morgan.harvard.edu; +Cc: pgsql-admin
Hi,
No - not conclusive reason to think it won't work - just would
like verification (if it exists) that it does work.
Note - though the targets are different, the file is being
opened/read by 2 different uncompress -c s...
Thanks
Susan
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2008-02-25 13:11 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-02-22 18:37 CORRECTION to msg 'loading same instance of dump to two different servers simultaneously' Susan Russo <russo@morgan.harvard.edu>
2008-02-22 19:18 ` D'Arcy J.M. Cain <darcy@druid.net>
2008-02-25 13:11 ` Matthew <matthew@flymine.org>
2008-02-22 19:24 Re: [PERFORM] CORRECTION to msg 'loading same instance of dump to two different servers simultaneously' Susan Russo <russo@morgan.harvard.edu>
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