Обсуждение: problems dumping from one server 2 another

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…

Would appreciate quick help,

sincerely

Victor Spång Arthursson

Copenhagen, Denmark and Malmoe, Sweden

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

2004-01-10 kl. 00.21 skrev Richard Huxton:

>> 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)

Hi and thanks for the tip!

Have created my .pgpass-file, and is able to connect as well to my
local server as to my remote server, each for them self.

This:

/usr/local/bin/psql -U user_local db_local

and:

/usr/local/bin/psql -U user_remote -h host_remote db_remote

works fine.

This, though, doesn't work:

/usr/local/bin/psql -U user_local db_local | /usr/local/bin/psql -U
user_remote -h host_remote db_remote

Any tips, anyone?

Sincerely

Victor