Message-ID: <47BF2235.6080801@serioustechnology.com>
Date: Fri, 22 Feb 2008 14:27:49 -0500
From: Geoffrey <lists@serioustechnology.com>
User-Agent: Thunderbird 1.5.0.8 (X11/20061025)
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: Re: loading same instance of dump to two different servers
	simultaneously?
References: <200802221834.m1MIYhvA001607@larrys.harvard.edu>
In-Reply-To: <200802221834.m1MIYhvA001607@larrys.harvard.edu>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

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