Is the postmaster running (with -i) at 'localhost
I get an error msg when run Zeos Database Explorer:
connectDBStart() -- connect() failed: No error
Is the postmaster running (with -i) at 'localhost'
and accepting connections on TCP/IP port '5432'?
How to resolv it?
# ps axww|grep postmaster
1025 ? S 0:00 /bin/sh /usr/bin/pg_ctl -D /var/lib/pgsql/data -p /us
r/bin/postmaster start
1028 ? S 0:00 /usr/bin/postmaster
1349 pts/0 R 0:00 grep postmaster
/var/lib/pgsql/data/pg_hba.conf:
local all trust
host all 127.0.0.1 255.255.255.255 trust
host all 192.168.1.95 255.255.0.0 trust
host all 192.168.1.95 255.255.0.0 password
host all 192.168.0.0 255.255.0.0 crypt
--
[m[1;37m�� �ӷ�:�E�i�֪��� bbs.yeskw.com�E[FROM: dns.hiperfect.com][m
I'm not sure what version of postgres you are using but if you are use 7.1.?
you edit the postgresql.conf file. The file is in the same location as the
data. Just uncomment the "tcpip_socket=false" and change the "false" to
"true". I'm giving fair warning "I'm a newbie". But this is how I fixed my
postgres on 7.1 RH
Hope this helps!
John
"cocl" <yeskw.bbs@bbs.yeskw.com> wrote in message
news:3j1YgB$89s@bbs.yeskw.com...
I get an error msg when run Zeos Database Explorer:
connectDBStart() -- connect() failed: No error
Is the postmaster running (with -i) at 'localhost'
and accepting connections on TCP/IP port '5432'?How to resolv it?
# ps axww|grep postmaster
1025 ? S 0:00 /bin/sh /usr/bin/pg_ctl -D
/var/lib/pgsql/data -p /us
Show quoted text
r/bin/postmaster start
1028 ? S 0:00 /usr/bin/postmaster
1349 pts/0 R 0:00 grep postmaster/var/lib/pgsql/data/pg_hba.conf:
local all trust
host all 127.0.0.1 255.255.255.255 trusthost all 192.168.1.95 255.255.0.0 trust
host all 192.168.1.95 255.255.0.0 password
host all 192.168.0.0 255.255.0.0 crypt--
[m[1;37m�� �ӷ�:�E�i�֪��� bbs.yeskw.com�E[FROM: dns.hiperfect.com][m