Обсуждение: Connection refused
Hello All,
I am getting this error when i am using sql-ledger
application. it is giving this error :
Error : could not connect to server: Connection refused
I have given these values : Host :192.168.168.56 User Name:SQL-ledger Password : SQL-ledger and connect to: Template1
I am getting this error when i am using sql-ledger
application. it is giving this error :
Error : could not connect to server: Connection refused
I have given these values : Host :192.168.168.56 User Name:SQL-ledger Password : SQL-ledger and connect to: Template1
where Template1 is the DB template in postgresql on RH Linux 7.3 (postgresql 7.2.X).I
created a user as sql-ledger
#su postgres
$ createuser -d sql-ledger
The post master is running and but the status is
# pg_ctl status
pg_ctl: no database directory or environment variable
$PGDATA is specified .
The default DB is template1.
But, in the html page it is giving this error. i want to
know how to solve this error.
i have also tried these :
# psql -h 192.168.168.56
psql: could not connect to server: Connection refused
Is the server running on host 192.168.168.56 and accepting
TCP/IP connections on port 5432?
and
# netstat -inp
Kernel Interface table
Iface MTU Met RX-OK RX-ERR RX-DRP RX-OVR TX-OK TX-ERR TX-DRP TX-OVR Flg
eth0 1500 0 35441 0 0 0 2549 0 0 0 BMRU
lo 16436 0 100 0 0 0 100 0 0 0 LRU
and
[root@perl users]# aux | grep postgres
postgres 1025 0.0 1.4 8128 1800 ? S Feb12 0:00 /usr/bin/postmast
postgres 1027 0.0 1.4 9120 1784 ? S Feb12 0:00 postgres: stats b
postgres 1028 0.0 1.4 8152 1820 ? S Feb12 0:00 postgres: stats c
and
[root@perl users]# pg_ctl status
pg_ctl: no database directory or environment variable $PGDATA is specified
i used kpackage and all the server and development installations are there.
we recently installed sql-ledger and this relies on postgres.
But it is not connecting .do i have to check env variables. how can i overcome this problem..
Thanks and regards,
Vivek
created a user as sql-ledger
#su postgres
$ createuser -d sql-ledger
The post master is running and but the status is
# pg_ctl status
pg_ctl: no database directory or environment variable
$PGDATA is specified .
The default DB is template1.
But, in the html page it is giving this error. i want to
know how to solve this error.
i have also tried these :
# psql -h 192.168.168.56
psql: could not connect to server: Connection refused
Is the server running on host 192.168.168.56 and accepting
TCP/IP connections on port 5432?
and
# netstat -inp
Kernel Interface table
Iface MTU Met RX-OK RX-ERR RX-DRP RX-OVR TX-OK TX-ERR TX-DRP TX-OVR Flg
eth0 1500 0 35441 0 0 0 2549 0 0 0 BMRU
lo 16436 0 100 0 0 0 100 0 0 0 LRU
and
[root@perl users]# aux | grep postgres
postgres 1025 0.0 1.4 8128 1800 ? S Feb12 0:00 /usr/bin/postmast
postgres 1027 0.0 1.4 9120 1784 ? S Feb12 0:00 postgres: stats b
postgres 1028 0.0 1.4 8152 1820 ? S Feb12 0:00 postgres: stats c
and
[root@perl users]# pg_ctl status
pg_ctl: no database directory or environment variable $PGDATA is specified
i used kpackage and all the server and development installations are there.
we recently installed sql-ledger and this relies on postgres.
But it is not connecting .do i have to check env variables. how can i overcome this problem..
Thanks and regards,
Vivek
MSN 8 helps ELIMINATE E-MAIL VIRUSES. Get 2 months FREE*.
find your postgresql.conf file, look in there to make sure tcpip_socket = true. the directory that file is in should be the same as the $PGDATA that your getting asked for, so you'll be able to do pg_ctl -D /path/to/database status Robert Treat On Wed, 2003-02-12 at 09:30, vivek K. wrote: Hello All, I am getting this error when i am using sql-ledger application. it is giving this error : Error : could not connect to server: Connection refused I have given these values : Host :192.168.168.56 User Name:SQL-ledger Password : SQL-ledger and connect to: Template1 where Template1 is the DB template in postgresql on RH Linux 7.3 (postgresql 7.2.X).I created a user as sql-ledger #su postgres $ createuser -d sql-ledger The post master is running and but the status is # pg_ctl status pg_ctl: no database directory or environment variable $PGDATA is specified . The default DB is template1. But, in the html page it is giving this error. i want to know how to solve this error. i have also tried these : # psql -h 192.168.168.56 psql: could not connect to server: Connection refused Is the server running on host 192.168.168.56 and accepting TCP/IP connections on port 5432? and # netstat -inp Kernel Interface table Iface MTU Met RX-OK RX-ERR RX-DRP RX-OVR TX-OK TX-ERR TX-DRP TX-OVR Flg eth0 1500 0 35441 0 0 0 2549 0 0 0 BMRU lo 16436 0 100 0 0 0 100 0 0 0 LRU and [root@perl users]# aux | grep postgres postgres 1025 0.0 1.4 8128 1800 ? S Feb12 0:00 /usr/bin/postmast postgres 1027 0.0 1.4 9120 1784 ? S Feb12 0:00 postgres: stats b postgres 1028 0.0 1.4 8152 1820 ? S Feb12 0:00 postgres: stats c and [root@perl users]# pg_ctl status pg_ctl: no database directory or environment variable $PGDATA is specified i used kpackage and all the server and development installations are there. we recently installed sql-ledger and this relies on postgres. But it is not connecting .do i have to check env variables. how can i overcome this problem.. Thanks and regards, Vivek ________________________________________________________________________ MSN 8 helps ELIMINATE E-MAIL VIRUSES. Get 2 months FREE*.