From: | Victor Spång Arthursson <victor(at)tosti(dot)dk> |
---|---|
To: | Richard Huxton <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: problems dumping from one server 2 another |
Date: | 2004-01-12 10:45:48 |
Message-ID: | 7BB10870-44EC-11D8-A7EB-00039344A3C4@tosti.dk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Victor Spång Arthursson | 2004-01-12 11:31:31 | Dump tables with pg_dump - no or different Owner |
Previous Message | Richard Huxton | 2004-01-12 10:12:07 | Re: insertion with trigger failed unexpectedly |