Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id B5F1C1337C26 for ; Thu, 7 Apr 2011 15:59:55 -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 62038-03-6 for ; Thu, 7 Apr 2011 18:59:48 +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 50D52133616B for ; Thu, 7 Apr 2011 15:58:53 -0300 (ADT) Received: by vxi39 with SMTP id 39so2188390vxi.19 for ; Thu, 07 Apr 2011 11:58:53 -0700 (PDT) Received: by 10.52.0.106 with SMTP id 10mr1713409vdd.257.1302202733093; Thu, 07 Apr 2011 11:58:53 -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 al15sm276216vdc.14.2011.04.07.11.58.51 (version=SSLv3 cipher=OTHER); Thu, 07 Apr 2011 11:58:52 -0700 (PDT) Message-ID: <4D9E09AD.7090801@consistentstate.com> Date: Thu, 07 Apr 2011 12:59:57 -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/16 X-Sequence-Number: 4178 Um, strike that link, just looked at the name and realized who posted that message. doh. 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 >