Re: Connecting PHP-based Application to Postgres-9.0.3

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

If nothing is appearing in the log after a restart and new connection attempts, that makes me think that the database isn't even receiving the connection attempt, which would mean either wrong connection credentials or something blocking it in between (since it looks like it's an app on the same machine as the database, that's most likely not it.

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: 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)



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[6652]: [1-1] LOG: database system is ready
to accept connections
Apr  7 11:13:14 salmo postgres[6656]: [1-1] LOG:  autovacuum launcher


[Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

Add to Google Powered by Linux