Re: How to move a database from HP server to Linux Server that had already one database.

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: How to move a database from HP server to Linux Server that had already one database.
Дата
Msg-id 201008100014.o7A0Enb03841@momjian.us
обсуждение исходный текст
Ответ на Re: How to move a database from HP server to Linux Server that had already one database.  ("ENGEMANN, DAYSE" <dayse.engemann@hp.com>)
Ответы Re: How to move a database from HP server to Linux Server that had already one database.
Re: How to move a database from HP server to Linux Server that had already one database.
Список pgsql-admin
Дерево обсуждения 
ENGEMANN, DAYSE wrote:
> Hi Kevin,
> Sorry to disturb you.. But I am really new in it...
> Let me see if I understood...
>
>  pg_dump -h sourcemachine -U sourceuser source_dbname | psql target_dbname

Has anyone done any measurement of whether it is faster to do the dump
on the local machine with psql remote or from a remote machine (where
psql would be local)?

--
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + It's impossible for everything to be true. +

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

Предыдущее
От: "Tomeh, Husam"
Дата:
Сообщение: Re: High-water Mark for number of sessions/connections reached in Postgres
Следующее
От: Rosser Schwarz
Дата:
Сообщение: Re: High-water Mark for number of sessions/connections reached in Postgres