pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
CORRECTION 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>
  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 19:18  D'Arcy J.M. Cain <darcy@druid.net>
  parent: Susan Russo <russo@morgan.harvard.edu>
  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: [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

* Re: CORRECTION to msg 'loading same instance of dump to two different servers simultaneously'
@ 2008-02-25 13:11  Matthew <matthew@flymine.org>
  parent: Susan Russo <russo@morgan.harvard.edu>
  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


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