Connection refused - Mailing list pgsql-admin

From vivek K.
Subject Connection refused
Date
Msg-id F663xAZS47eCOQxzW1900009c79@hotmail.com
Whole thread Raw
Responses Re: Connection refused
List pgsql-admin
<div style="background-color:"><div>Hello All,<br />I am getting this error when i am using sql-ledger <br
/>application.it is giving this error : <br />Error : could not connect to server: Connection refused <br />I have
giventhese values : Host :192.168.168.56 User Name:SQL-ledger Password : SQL-ledger and connect to: Template1
</div><div>whereTemplate1 is the DB template in postgresql on RH Linux 7.3 (postgresql 7.2.X).I <br />created a user 
assql-ledger <br />#su postgres <br />$ createuser -d sql-ledger <br />The post master is running and but the status is
<br/># pg_ctl status <br />pg_ctl: no database directory or environment variable <br />$PGDATA is specified . <br />The
defaultDB is template1. <br />But, in the html page it is giving this error. i want to <br />know how to solve this
error.<br />i have also tried these : <br /># psql -h 192.168.168.56 <br />psql: could not connect to server:
Connectionrefused <br />Is the server running on host 192.168.168.56 and accepting <br />TCP/IP connections on port
5432?<br />and <br /># netstat -inp <br />Kernel Interface table <br />Iface MTU Met RX-OK RX-ERR RX-DRP RX-OVR TX-OK
TX-ERRTX-DRP TX-OVR Flg <br />eth0 1500 0 35441 0 0 0 2549 0 0 0 BMRU <br />lo 16436 0 100 0 0 0 100 0 0 0 LRU <br
/>and<br />[root@perl users]# aux | grep postgres <br />postgres 1025 0.0 1.4 8128 1800 ? S Feb12 0:00
/usr/bin/postmast<br />postgres 1027 0.0 1.4 9120 1784 ? S Feb12 0:00 postgres: stats b <br />postgres 1028 0.0 1.4
81521820 ? S Feb12 0:00 postgres: stats c <br />and <br />[root@perl users]# pg_ctl status <br />pg_ctl: no database
directoryor environment variable $PGDATA is specified <br />i used kpackage and all the server and development
installationsare there. <br />we recently installed sql-ledger and this relies on postgres. <br />But it is not
connecting.do i have to check env variables. how can i overcome this problem.. <br />Thanks and regards, <br />Vivek
</div></div><brclear="all" /><hr />MSN 8 helps <a href="http://g.msn.com/8HMQEN/2743">ELIMINATE E-MAIL VIRUSES. </a>
Get2 months FREE*. 

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: server won't shutdown
Next
From: Andreas Schmitz
Date:
Subject: ERROR: deadlock detected