Postgres Pro
Downloads
Home   >   mailing lists

Re: server doesn't listen postgresql 9.1 after service change - Mailing list pgsql-admin

From Harshad Adalkonda
Subject Re: server doesn't listen postgresql 9.1 after service change
Date
Msg-id CANnQH_g_8pTWvRGnjb--m9=_pvyTVN8Upjso493PwYgK5p_poQ@mail.gmail.com
Whole thread Raw
In response to Re: server doesn't listen postgresql 9.1 after service change  (danny <dinesh4202001@gmail.com>)
List pgsql-admin
Tree view

On Fri, Apr 24, 2015 at 9:42 PM, danny <dinesh4202001@gmail.com> 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

http://www.postgresql.org/docs/9.1/static/index.html

Hope above solution will solve your problem.

--
Thanks & Regards,
Harshad Adalkonda
Database Administrator
www.shreeyansh.com

pgsql-admin by date:

Previous
From: Andre_Mikulec
Date:
Subject: How do I install/run PostgreSQL 9.4 64 bit on Windows 7 Professional?
Next
From: Albe Laurenz
Date:
Subject: Re: How do I install/run PostgreSQL 9.4 64 bit on Windows 7 Professional?