Re: problems dumping from one server 2 another

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: problems dumping from one server 2 another
Дата
Msg-id 200401092321.16741.dev@archonet.com
обсуждение исходный текст
Ответ на problems dumping from one server 2 another  (Victor Spång Arthursson <victor@tosti.dk>)
Ответы Re: problems dumping from one server 2 another  (Victor Spång Arthursson <victor@tosti.dk>)
Список pgsql-general
Дерево обсуждения 
On Friday 09 January 2004 14:38, Victor Spång Arthursson wrote:
> Hi!
>
> Can't get the
>
> sudo -u user1 /usr/local/bin/pg_dump db1 | /usr/local/bin/psql -U user2
> -h host2 db2
>
> to work.
>
> Only thing that happens is that I get multiple passwordprompts, and
> then I gets told that the password is incorrect…

You probably want a .pgpass file - see the section on libpq in the manuals
(client interfaces / libpq / files)

--
  Richard Huxton
  Archonet Ltd

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: ERROR: Cannot insert a duplicate key into unique index pg_class_relname_nsp_index
Следующее
От: "Aurangzeb M. Agha"
Дата:
Сообщение: Re: no space left on device