Re: problems dumping from one server 2 another - Mailing list 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