On Fri, Apr 24, 2015 at 9:42 PM, danny <dinesh4202001@xxxxxxxxx> wrote:
Hi Danny,
1)
Harshad,
Thanks for the reply I did check logs and now its working I did change
services butnow I want to know how can I establish connection between client machine to server
Run the following command from cmd by cd C:\Program Files\PostgreSQL\9.1\bin directory of postgresql
psql -h ip address dbserver -U username -d dbname -p port
Ex:
psql -h 192.168.0.110 -U postgres -d postgres -p 5432 (From other system ip entry should be present in pg_hba.conf of postgresql)
psql -h 127.0.0.1 -U postgres -d postgres -p 5432 (From localhost/ same system)
2)
and how I know if PostgreSQL is running under same service I mentioned still it is asking for default password which I have
given during installation
Is it asking password for service or while connecting to psql terminal ?
For psql terminal it will ask password because it is md5 is default security in postgresql server.
Following PostgreSQL Document link will help you to solve your problems
Hope above solution will solve your problem.
--
Thanks & Regards,
Harshad Adalkonda
Database Administrator
www.shreeyansh.com
Harshad Adalkonda
Database Administrator
www.shreeyansh.com
