Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 4C8B2133616B for ; Thu, 7 Apr 2011 15:57:31 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 52841-04 for ; Thu, 7 Apr 2011 18:57:23 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail-vx0-f174.google.com (mail-vx0-f174.google.com [209.85.220.174]) by mail.postgresql.org (Postfix) with ESMTP id 91EE913364DE for ; Thu, 7 Apr 2011 15:57:23 -0300 (ADT) Received: by vxi39 with SMTP id 39so2187360vxi.19 for ; Thu, 07 Apr 2011 11:57:23 -0700 (PDT) Received: by 10.52.92.161 with SMTP id cn1mr1818488vdb.253.1302202643136; Thu, 07 Apr 2011 11:57:23 -0700 (PDT) Received: from sidon.consistentstate.com (173-164-51-9-colorado.hfc.comcastbusiness.net [173.164.51.9]) by mx.google.com with ESMTPS id cc16sm474894vdb.20.2011.04.07.11.57.20 (version=SSLv3 cipher=OTHER); Thu, 07 Apr 2011 11:57:21 -0700 (PDT) Message-ID: <4D9E0952.4080803@consistentstate.com> Date: Thu, 07 Apr 2011 12:58:26 -0600 From: Brian Fehrle User-Agent: Mozilla/5.0 (X11; U; Linux i686 (x86_64); en-US; rv:1.9.2.15) Gecko/20110303 Lightning/1.0b2 Thunderbird/3.1.9 MIME-Version: 1.0 To: pgsql-php@postgresql.org Subject: Re: Connecting PHP-based Application to Postgres-9.0.3 References: <201104070920.37258@hal.medialogik.com> <20110407125635.1ae13751.wmoran@potentialtech.com> <20110407132029.be595363.wmoran@potentialtech.com> <4D9DFAB2.2080902@consistentstate.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201104/15 X-Sequence-Number: 4177 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 -U 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[6652]: [1-1] LOG: database system is > ready > to accept connections > Apr 7 11:13:14 salmo postgres[6656]: [1-1] LOG: autovacuum launcher > started > > Rich >