I'd verify that the full connection string is correct, host, port, user, and database name. Connect with psql like you did before, but specify all the parameters:
psql -h localhost -p <port> -U <user> <database name>and if it works, make sure it's the same information in the configuration for your application.
Also, this may help: http://forum.cmsmadesimple.org/viewtopic.php?t=53350&p=251336 as it mentions something about changing postgres7 to just postgres in the config.php file.
- Brian F Consistent State On 04/07/2011 12:17 PM, Rich Shepard wrote:
On Thu, 7 Apr 2011, Brian Fehrle wrote:In the postgresql.conf file, look for these parameters.log_destination (can be set to stderr, csvlog, syslog, and eventlog, you probably want syslog). log_connections (default is off, turn this on to see all connection attempts to the database)log_disconnections (same as log_connections)Brian, Hmm-m-m.log_destination = 'syslog' # Valid values are combinations of # stderr, csvlog, syslog, and eventlog,# depending on platform. csvlog# requires logging_collector to be on.log_connections = on log_disconnections = on Yet, there's noting in /var/log/messages after restarting postgres.Apr 7 11:13:14 salmo postgres: [1-1] LOG: database system is readyto accept connections Apr 7 11:13:14 salmo postgres: [1-1] LOG: autovacuum launcher started Rich