psql password passing problem
От | pascal Van Puymbroeck |
---|---|
Тема | psql password passing problem |
Дата | |
Msg-id | 4A857C10.1050108@zenonproductions.be обсуждение исходный текст |
Ответы |
Re: psql password passing problem
|
Список | pgsql-hackers |
Hi guys, I'd like to inform you about the issue of using psql in a dos batch file on windows vista. On linux all is very simple, you can easily write in your script psql -d mydb -U myuser -f myqry.sql < passw.txt On windows however, psql does not seem to work like this, nor does type passwd.txt | psql -d mydb -U myuser -f myqry.sql work So I tried using psql -d mydb -U myuser -f myqry.sql -u PGPASSWORD=xxxxxx But this does not work either, so I turned to the pgpass.conf file and it seemed like that didn't work either because I wrote 127.0.0.1:5432:mydb:myuser:xxxxxx so I experimented and the hostname command in my dosbox gave me mistral, so I tried mistral:5432:mydb:myuser:xxxxxx And this did not work either so at last I tried localhost:5432:mydb:myuser:xxxxxx And this worked. I also noticed that PGadmin also displayed my machine as server 8.3 (localhost:5432). Maybe this can be fixed in the future, that an ip-address or name of machine is accepted too ? Keep up the good work, Pascal Van Puymbroeck ZENON productions bvba BELGIUM
В списке pgsql-hackers по дате отправления: