Hi,
> 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 ? The first thing that comes to mind is, what is you; listen_address set to? HTH. Regards, Serge Fonville
