Re: loading same instance of dump to two different servers simultaneously?

From: Geoffrey <lists(at)serioustechnology(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: loading same instance of dump to two different servers simultaneously?
Date: 2008-02-22 19:27:49
Message-ID: 47BF2235.6080801@serioustechnology.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-performance

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Asche 2008-02-22 22:40:32 Strange Authentication Problem
Previous Message Geoffrey 2008-02-22 19:26:39 Re: loading same instance of dump to two different servers simultaneously?

Browse pgsql-performance by date

  From Date Subject
Next Message Kynn Jones 2008-02-22 20:49:59 Q on views and performance
Previous Message Geoffrey 2008-02-22 19:26:39 Re: loading same instance of dump to two different servers simultaneously?