Обсуждение: CORRECTION to msg 'loading same instance of dump to two different servers simultaneously'
SORRY - these are the commands (i.e. pgserver-A and pgserver-B) ====== 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-B pg-dbname ===== S
Re: [PERFORM] CORRECTION to msg 'loading same instance of dump to two different servers simultaneously'
От
"D'Arcy J.M. Cain"
Дата:
No need to crosspost. I removed -performance from the Cc. On Fri, 22 Feb 2008 13:37:43 -0500 (EST) Susan Russo <russo@morgan.harvard.edu> wrote: > 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. Do you have any reason to doubt that this would work? Have you tried it? As long as the targets are different I don't see any problem. -- D'Arcy J.M. Cain <darcy@druid.net> | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.