<html><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 given these values : Host :192.168.168.56 User Name:SQL-ledger Password : SQL-ledger and connect to: Template1 </DIV>
<DIV>where Template1 is the DB template in postgresql on RH Linux 7.3 (postgresql 7.2.X).I <BR>created a user as sql-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 default DB 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: Connection refused <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-ERR TX-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(at)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 8152 1820 ? S Feb12 0:00 postgres: stats c <BR>and <BR>[root(at)perl users]# pg_ctl status <BR>pg_ctl: no database directory or environment variable $PGDATA is specified <BR>i used kpackage and all the server and development installations are 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><br clear=all><hr>MSN 8 helps <a href="http://g.msn.com/8HMQEN/2743">ELIMINATE E-MAIL VIRUSES. </a> Get 2 months FREE*.</html>