Topic: SME 6.0.1 and Postgresql

[mophilly]

I have attempted to install the Postgresql using the How-to at Sleepy SME. Please refer to http://tinyurl.com/3j3yp.

The installation appears to have worked and the psql process is up... I think. All went well until step 8: "Testing access to postgresQL"

When I enter
[root]# psql postgrestest -h localhost -U jesuistest
I get...
psql: FATAL:  missing or erroneous pg_hba.conf file
HINT:  See server log for details.

I have tried a number of variations for "localhost" including various IP addresses and so on. No joy.

Where should I look for the server log?

[mophilly]

Well, I got it work by fiddling with contents of pg_hba.conf. Finicky bit of business. I am not confident I really grok the permissions so off to the library.