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 |
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 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
From | Date | Subject | |
---|---|---|---|
Next Message | Geoffrey | 2008-02-22 19:27:49 | Re: loading same instance of dump to two different servers simultaneously? |
Previous Message | Milen Evtimov | 2008-02-22 19:25:03 | Re: server process (PID ) was terminated by signal 29 |
From | Date | Subject | |
---|---|---|---|
Next Message | Geoffrey | 2008-02-22 19:27:49 | Re: loading same instance of dump to two different servers simultaneously? |
Previous Message | D'Arcy J.M. Cain | 2008-02-22 19:18:03 | Re: [PERFORM] CORRECTION to msg 'loading same instance of dump to two different servers simultaneously' |