Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 61F4F9F9BD0 for ; Tue, 4 Sep 2007 15:12:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 00898-01-7 for ; Tue, 4 Sep 2007 15:12:38 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from outbound-mail-60.bluehost.com (outbound-mail-60.bluehost.com [69.89.20.40]) by postgresql.org (Postfix) with SMTP id 9D2BD9FA144 for ; Tue, 4 Sep 2007 15:12:18 -0300 (ADT) Received: (qmail 30502 invoked by uid 0); 4 Sep 2007 18:12:17 -0000 Received: from unknown (HELO box54.bluehost.com) (69.89.20.54) by mailproxy3.bluehost.com with SMTP; 4 Sep 2007 18:12:17 -0000 Received: from rrcs-71-41-16-51.sw.biz.rr.com ([71.41.16.51] helo=[10.0.12.106]) by box54.bluehost.com with esmtp (Exim 4.66) (envelope-from ) id 1IScsq-00006d-Hx for pgsql-admin@postgresql.org; Tue, 04 Sep 2007 12:12:16 -0600 From: Kevin Kempter To: pgsql-admin@postgresql.org Subject: Re: default port number Date: Tue, 4 Sep 2007 12:08:53 -0600 User-Agent: KMail/1.9.7 References: <200709041109.42925.kevin@kevinkempterllc.com> In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200709041208.53976.kevin@kevinkempterllc.com> X-Identified-User: {840:box54.bluehost.com:kevinkem:kevinkempterllc.com} {sentby:bopbeforesmtp 71.41.16.51 authed with kevinkempterllc.com} X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.238 tagged_above=0 required=5 tests=AWL=0.218, BAYES_05=-1.11, DNS_FROM_OPENWHOIS=1.13 X-Spam-Level: X-Archive-Number: 200709/20 X-Sequence-Number: 26781 On Tuesday 04 September 2007 12:06:29 Tena Sakai wrote: > Thank you, Kevin Kempter. > Thank you, Kevin Grittner, > > In order for me to accept foreign odbc connection, > one of the things I must to is to change > listen_addresses = 'localhost' > to something like: > listen_addresses = 'ip-address-A, ip-address-B' > > But those machines on the list are dhcp clients > and their ip addresses change from time to time. > Is there something I can do to accomodate such > moving targets? You can use hostnames instead of I.P.'s or you can set: listen_addresses = '*' Note that just because postgres will listen to all hosts ('*') the actual authentication access is controlled by pg_hba.conf > > Regards, > > Tena Sakai > tsakai@gallo.ucsf.edu > > > > -----Original Message----- > From: pgsql-admin-owner@postgresql.org on behalf of Kevin Kempter > Sent: Tue 9/4/2007 10:09 AM > To: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] default port number > > On Tuesday 04 September 2007 10:59:38 Tena Sakai wrote: > > Hi Everybody, > > > > I had been running postgres with postgresql.conf file > > as little changed as possible from distributed version. > > And lately I became a bit curious as well as confused. > > > > In my configuration file both lines > > #listen_addresses = 'localhost' > > and > > #port = 5432 > > are commented out. > > > > What does this mean? Is postgress listening on port > > 5432? > > > > Regards, > > > > Tena Sakai > > tsakai@gallo.ucsf.edu > > The above values are the defaults, postgres should be listening on port > 5432 and only listening on localhost for connections. You can double check > by running these commands in a psql session: > > show listen_addresses ; > > show port ; > > > /Kevin > > ---------------------------(end of broadcast)--------------------------- > TIP 7: You can help support the PostgreSQL project by donating at > > http://www.postgresql.org/about/donate