Connection to database problem

[francoisjacquet]

Connection to database problem

[francoisjacquet]

Hi zeine77,

Those tests are simply to avoid specifying the host and the port if those are the default ones.
This can avoid problems like this one: http://www.php.net/manual/en/function.pg-connect.php#38291

FYI, I never experienced a problem connecting from localhost and port 5432, so I think you should look on the side of your PostgreSQL config instead.

[zeine77]

Hello again,

I reviewed my postgresql config, it seems ok.
I'm using postgresql 8.4 on Ubuntu 12.04 LTS 64 bit.

Here are my two config files

postgresql.conf (I posted just the "CONNECTIONS AND AUTHENTICATION" section)
http://pastebin.com/RPXbm38k

pg_hba.conf
http://pastebin.com/4ajfDeN0

And this is the home page I get
http://pastebin.com/FAhtC2w0

when I commented the two tests evrything ran I it expected to do.

Thanks again for your time.

[francoisjacquet]

Hi zeine77,

Thanks for posting you PostgreSQL config.
After a review, in pg_hba.conf, the line about Database administrative login by Unix domain socket is different on my config.
You have:
local all postgres ident

I have instead:
local all postgres peer

As for the connection error on your home page, the Additional Information is missing. Please check the Apache error log in hope there is a more useful error message.

[zeine77]

Thanks a lot for your replay.

I changed my pg_hba.conf so it looks now like this

#Database administrative login by Unix domain socket
local all postgres trust

I tried 'peer' but it didn't recognize it (probably because my version: 8.4).

Now it works great.