Re: Password?

Ms swati chande wrote:
>
>     ....
>              Made the following change in the postgresql.conf file:
>                      listen_addresses = 'xxx.xxx.x.x' (my current ip)
>              and in pg_hba:
>                      host all all 'xxx.xxx.x.x' trust
>
>     ...
>     6.Opened another command window.
>        Now when I write in the new window (or even in the same),
>                      c:\postgresql\bin>createdb demo
>        OR
>                      c:\postgresql\bin>createuser -S -d -R svc
>        I am prompted for password, I don't know what to enter here.
>
>

try ...
    createuser -h xxx.xxx.x.x -S -d -R svc

by default, its connecting to localhost (127.0.0.1) rather than your IP.

(note this behavior is different than on Unix/Linux type systems, where
by default it connects to a 'unix domain socket', which doesn't exist on
MS Windows).




If you only want to connect to this database from the same computer, I'd
suggest using 127.0.0.1/localhost rather than xxx.xxx.x.x in both the
listen_address and pg_hba...