Re: server doesn't listen postgresql 9.1 after service change

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux