| From: | Jeremiah Megie <jmegie(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Unix Domain Socket Error |
| Date: | 2005-02-21 16:24:52 |
| Message-ID: | 5b584db20502210824195d0b68@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
I've used postgres before numerous times, but I can't seem to correct
this issue. I am using PostgreSQL 7.3.4 and Fedora Core 1. I had
postgres setup and working correctly. My php scripts were interfacing
with it, no problems.
We then had our server re-formatted and had ensim installed. The
virtual domains don't seem to use postgres independantly (like apache,
sendmail, etc.). So, I imported my existing database and it works
fine from the command prompt.
However, I cannot access it from the web:
http://creatyve.zgsolutions.com/php/glossary/
And I cannot login using phpPgAdmin.
I get the following error:
Warning: pg_connect(): Unable to connect to PostgreSQL server: could
not connect to server: Permission denied Is the server running locally
and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
in /home/virtual/site2/fst/home/jeremiah/public_html/creatyve/php/glossary/common.php
on line 196
Warning: pg_connect(): Unable to connect to PostgreSQL server: could
not connect to server: Permission denied Is the server running locally
and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
in /home/virtual/site2/fst/home/jeremiah/public_html/creatyve/php/glossary/index.php
on line 34
Could not open connection to database server
I know it's not a problem in the code because it was working two days
ago on the other server. I've checked pg_hba.conf, and it seems
correct, although I'm not sure.
I also tried adding the '-i' option to the daemon startup, but it fails.
Any suggestions guys?
Thanks for any help!
Jeremiah
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-02-21 16:33:52 | Re: PGS 7.2 : Insert with wrong number of values did not fail |
| Previous Message | Bo Lorentsen | 2005-02-21 16:14:02 | Re: Deadlock and FK triggers |