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

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


Responses

pgsql-performance by date

Next:From: D'Arcy J.M. CainDate: 2008-02-22 19:18:03
Subject: Re: [PERFORM] CORRECTION to msg 'loading same instance of dump to two different servers simultaneously'
Previous:From: Susan RussoDate: 2008-02-22 18:34:43
Subject: loading same instance of dump to two different servers simultaneously?

pgsql-admin by date

Next:From: D'Arcy J.M. CainDate: 2008-02-22 19:18:03
Subject: Re: [PERFORM] CORRECTION to msg 'loading same instance of dump to two different servers simultaneously'
Previous:From: Susan RussoDate: 2008-02-22 18:34:43
Subject: loading same instance of dump to two different servers simultaneously?

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