Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: mophilly on March 03, 2005, 01:18:06 AM

Title: SME 6.0.1 and Postgresql
Post by: mophilly on March 03, 2005, 01:18:06 AM

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?

Title: Re: SME 6.0.1 and Postgresql
Post by: mophilly on March 03, 2005, 06:57:51 PM

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.