Re: [GENERAL] Is the postmaster running (with -i) at 'localhost

[John Fabiani]

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" <[EMAIL PROTECTED]> wrote in message
news:3j1YgB$[EMAIL PROTECTED]...
> 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]



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])