Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 38C0B1337C02 for ; Thu, 7 Apr 2011 15:17:57 -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 89587-03 for ; Thu, 7 Apr 2011 18:17:50 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from salmo.appl-ecosys.com (appl-ecosys.com [216.99.206.23]) by mail.postgresql.org (Postfix) with ESMTP id B98951337C01 for ; Thu, 7 Apr 2011 15:17:49 -0300 (ADT) Received: by salmo.appl-ecosys.com (Postfix, from userid 1000) id 23B3137BC6; Thu, 7 Apr 2011 11:17:49 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by salmo.appl-ecosys.com (Postfix) with ESMTP id 1B52837B42 for ; Thu, 7 Apr 2011 11:17:49 -0700 (PDT) Date: Thu, 7 Apr 2011 11:17:49 -0700 (PDT) From: Rich Shepard To: pgsql-php@postgresql.org Subject: Re: Connecting PHP-based Application to Postgres-9.0.3 In-Reply-To: <4D9DFAB2.2080902@consistentstate.com> Message-ID: References: <201104070920.37258@hal.medialogik.com> <20110407125635.1ae13751.wmoran@potentialtech.com> <20110407132029.be595363.wmoran@potentialtech.com> <4D9DFAB2.2080902@consistentstate.com> User-Agent: Alpine 2.00 (LNX 1167 2008-08-23) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201104/14 X-Sequence-Number: 4176 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