loading same instance of dump to two different servers simultaneously?

Поиск
Список
Период
Сортировка
От Susan Russo
Тема loading same instance of dump to two different servers simultaneously?
Дата
Msg-id 200802221834.m1MIYhvA001607@larrys.harvard.edu
обсуждение исходный текст
Список pgsql-performance
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


В списке pgsql-performance по дате отправления:

Предыдущее
От: Susan Russo
Дата:
Сообщение: CORRECTION to msg 'loading same instance of dump to two different servers simultaneously'
Следующее
От: "Kynn Jones"
Дата:
Сообщение: Q on views and performance