Re: Is the postmaster running (with -i) at 'localhost - Mailing list pgsql-general

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
>
> --
> �� �ӷ�:�E�i�֪��� bbs.yeskw.com�E[FROM: dns.hiperfect.com]