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...
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
