Postgres Pro
Downloads
Home   >   mailing lists

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

loading same instance of dump to two different servers simultaneously?

From
Susan Russo
Date:
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

Thanks for any advice.
Susan Russo

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

From
Geoffrey
Date:
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

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

From
Geoffrey
Date:
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