Iñigo Barandiaran wrote:
> Thank you all!
>
> and Thanks Sam for the explanation about environment variable. I didn't
> know about that :)
>
> I've also tried the option of .pgpass file, that as far as I understand
> in Windows is pgpass.conf. I did a file containing only this line
>
> /*/:/*///:/*///:/MyPostgres///User/:MyPostgres://Password
If you want to run psql logged into your machine as "inigo" and connect
to "mydb1" as user "pguser1" with password "pass1" then the line should be:
localhost:5432:mydb1:pguser1:pass1
You might want some stars in there
*:*:*:pguser1:pass1
> /I put this file in:
> c:\MyPosgreInstalation and c:\MyPosgreInstalation\bin and
> c:\MyPosgreInstalation\data and
> C:\Documents and Settings\postgres\Application Data\
If you are logged into your machine as "inigo" it would go into:
C:\Documents and Settings\inigo\Application Data\postgresql\pgpass.conf
If you logged into your machine as user "richard" you would need to
create a new pgpass.conf file and put it in richard's "Application Data"
folder.
--
Richard Huxton
Archonet Ltd