Hi,
I'm having some troubles getting pg_connect() to connect over UNIX
domain sockets. Something that really confuses me is the error string
being served up by apache. It says it was unable to connect to
database xxxx. However, the characters are gibberrish. At first I
thought that my problem was that I forgot to give the user name also
(seeing there was no apache user in postgresql). However that wasn't
it. To make sure though, I added an apache username to the postgresql
server.
Currently, my pg_connect looks like this:
$dbconn = pg_connect("dbname=mydb user=andy");
I have checked the pg_hba.conf file, but that shouldn't be it as I can
connect via psql over UNIX domain. However, given my current
predicament, I'd like any and all suggestions.
Andt