Postgresql configuration

[kshim5]

This is my problem i installed postgresql on my RedHat linux 9 box and for the life of me i cant get it to work, I edited the /var/lib/pgsql/data/pg_hba.conf
file and inserted

# TYPE DATABASE ....... AUTH_TYPE
host local trust

Now according to the documentation this should allows any user to login to the database locally when i try to login with psql even as postgres
i get this error any ideas why its doing this

psql: FATAL 1: No pg_hba.conf entry for host localhost, user kshim5, database kshim5

[mdwatts]

Originally posted by kshim5
No pg_hba.conf entry for host localhost, user kshim5, database kshim5

This is just a guess since I've never used Postgresql.

Do you need to restart Postgresql since you updated pg_hba.conf?

That or you need a localhost entry in /etc/hosts.

127.0.0.1 localhost.localdomain localhost

[stumbles]

[i] I edited the /var/lib/pgsql/data/pg_hba.conf
file and inserted

# TYPE DATABASE ....... AUTH_TYPE
host local trust

Now according to the documentation this should allows any user to login to the database locally when i try to login with psql even as postgres
i get this error any ideas why its doing this

psql: FATAL 1: No pg_hba.conf entry for host localhost, user kshim5, database kshim5 [/B]

I think the pg_hba.conf should look like this;

# TYPE DATABASE USER IP-ADDRESS IP-MASK METHOD

local all all trust
host all all 127.0.0.1 255.255.255.255 trust

[kshim5]

I've tried all of the above and yet i still get the same error so i eventually uninstalled the .rpm version of postgresql and compiled it form source, this time it works fine maybe the people ar RedHat or whoever Didnt do something right with this software, i went and did a google search and found numerous complaints about the same problem so i guess i wasn,t the only one having the same problem. It works fine now all i have to do now is to figure out how to enable the postmaster to start at boot up and i'm good to go.


Thanks for you help guys

[stumbles]

Originally posted by kshim5
I've tried all of the above and yet i still get the same error so i eventually uninstalled the .rpm version of postgresql and compiled it form source, this time it works fine maybe the people ar RedHat or whoever Didnt do something right with this software, i went and did a google search and found numerous complaints about the same problem so i guess i wasn,t the only one having the same problem. It works fine now all i have to do now is to figure out how to enable the postmaster to start at boot up and i'm good to go.


Thanks for you help guys


You should be able to use the startup script RH installs when you rpm postgres, assuming you used the same paths, etc when compling from source.