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
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
