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
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
_______________________________________________ CentOS mailing list CentOS@xxxxxxxxxx http://lists.centos.org/mailman/listinfo/centos
