Thread: 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 > 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