Skip site navigation (1) Skip section navigation (2)

loading same instance of dump to two different servers simultaneously?

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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


Responses

pgsql-performance by date

Next:From: Susan RussoDate: 2008-02-22 18:37:43
Subject: CORRECTION to msg 'loading same instance of dump to two different servers simultaneously'
Previous:From: MatthewDate: 2008-02-22 15:49:34
Subject: Re: store A LOT of 3-tuples for comparisons

pgsql-admin by date

Next:From: Susan RussoDate: 2008-02-22 18:37:43
Subject: CORRECTION to msg 'loading same instance of dump to two different servers simultaneously'
Previous:From: Alvaro HerreraDate: 2008-02-22 18:27:24
Subject: Re: Stray autovacuum daemon

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group