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

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:26:39
Message-ID: 47BF21EF.4050700@serioustechnology.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-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 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

In response to

pgsql-performance by date

Next:From: GeoffreyDate: 2008-02-22 19:27:49
Subject: Re: loading same instance of dump to two different servers simultaneously?
Previous: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'

pgsql-admin by date

Next:From: GeoffreyDate: 2008-02-22 19:27:49
Subject: Re: loading same instance of dump to two different servers simultaneously?
Previous:From: Milen EvtimovDate: 2008-02-22 19:25:03
Subject: Re: server process (PID ) was terminated by signal 29

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