[CentOS] /etc/hosts missing localhost?

Tue Jul 29 09:43:15 UTC 2008
kapil singh <kapilsingh.linux at gmail.com>

Hello,
what about your postgresql settings ?
are you creating a role for connecting to postgres ?
if not creat role:

# /etc/init.d/postgresql restart
#su - postgres

(try to connecting here using your command psql -h, if it connects)
now,
(run command for creating role and setting up priviledges for other users.)

#creatuser -U postgres -P
....
...
...
edit the file /var/lib/pgsql/data/pg_hba.conf

and at the last lines it looks like:
# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# "local" is for Unix domain socket connections only
local   all         all                               trust
# IPv4 local connections:
host    all         all         127.0.0.1/32          trust
# IPv6 local connections:
host    all         all         ::1/128               ident sameuser

Good Luck


-- 
Thanks and Regards,
Kapil Singh Kushwah
Linux System Administrator
Hotwax Media Inc.
Indore,(M.P) INDIA
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.centos.org/pipermail/centos/attachments/20080729/5757abf9/attachment-0005.html>