From: Geoffrey <lists@serioustechnology.com>
To: pgsql-admin@postgresql.org
Subject: Re: loading same instance of dump to two different servers simultaneously?
Date: Fri, 22 Feb 2008 14:26:39 -0500
Message-ID: <47BF21EF.4050700@serioustechnology.com> (raw)
In-Reply-To: <200802221834.m1MIYhvA001607@larrys.harvard.edu>
References: <200802221834.m1MIYhvA001607@larrys.harvard.edu>
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 don't think this is really a postgres question, but the fact you're on
a UNIX type of OS, you should have no problem doing this. uncompress
will simply open the file separately for each shell session.
--
Until later, Geoffrey
Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
- Benjamin Franklin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: lists@serioustechnology.com, pgsql-admin@postgresql.org
Subject: Re: loading same instance of dump to two different servers simultaneously?
In-Reply-To: <47BF21EF.4050700@serioustechnology.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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