i must say that i newer used posgre (just mysql and mssql), but if you can acces the database with command line just make an backup of the databases and recreate them, after that insert the backup. also can be an rights isue, maibe apache has no rights to acces the databases.

Never worked with postgres. How about "pg_connect &"?

Howdy!


I am pasting you some add on PHP forum - maybe help

"If you use pg_connect('host=localhost port=5432 user=my_username password=my_password dbname=my_dbname') and you get the following error:
"Warning: pg_connect(): Unable to connect to PostgreSQL server: could not connect to server: Connection refused Is the server running on host localhost and accepting TCP/IP connections on port 5432?"
then you should try to leave the host= and port= parts out of the connection string. This sounds strange, but this is an "option" of Postgre. If you have not activated the TCP/IP port in postgresql.conf then postgresql doesn't accept any incoming requests from an TCP/IP port. If you use host= in your connection string you are going to connect to Postgre via TCP/IP, so that's not going to work. If you leave the host= part out of your connection string you connect to Postgre via the Unix domain sockets, which is faster and more secure, but you can't connect with the database via any other PC as the localhost."

You can check open ports with Nmap: just issue the command

"nmap localhost"

Good luck!