X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id AB29A9FA5E7 for ; Fri, 9 Jun 2006 12:09:29 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 49719-01 for ; Fri, 9 Jun 2006 12:09:25 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from news.hub.org (news.hub.org [200.46.204.72]) by postgresql.org (Postfix) with ESMTP id 068489FA098 for ; Fri, 9 Jun 2006 12:09:25 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.13.1/8.13.1) with ESMTP id k59F9OrY046189 for ; Fri, 9 Jun 2006 12:09:24 -0300 (ADT) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.13.1/8.13.1/Submit) id k59F43nJ044752 for pgsql-admin@postgresql.org; Fri, 9 Jun 2006 12:04:03 -0300 (ADT) (envelope-from news) From: Chris Browne X-Newsgroups: pgsql.admin Subject: Re: Database port changing issue Date: Fri, 09 Jun 2006 10:22:40 -0400 Organization: cbbrowne Computing Inc Lines: 36 Message-ID: <60d5diwgr3.fsf@dba2.int.libertyrms.com> References: <20060609133051.51979.qmail@web31010.mail.mud.yahoo.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Complaints-To: usenet@news.hub.org User-Agent: Gnus/5.1007 (Gnus v5.10.7) XEmacs/21.4.19 (linux) Cancel-Lock: sha1:/I7tuZ2vf/v1hTvouzu2THky8Bk= To: pgsql-admin@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/73 X-Sequence-Number: 22035 gbarosio@gmail.com ("Guido Barosio") writes: > That's because your listen_addresses parameter points to localhost, > and that means that your will listen for connections through unix > sockets instead of via TCP/IP. > > In order to change this, you'll need to replace the string localhost > with the proper value. (A bad habit, to replace the 'localhost' with a > '*'). > > Read the man page :) > > # - Connection Settings - > listen_addresses = 'localhost' # what IP address(es) to listen on; > > # Would be something like: > listen_addresses = '*' We found that listen_addresses='*' turned out fairly badly on AIX 5.3... When we did so, the stats collector wouldn't start up, and there would be complaints about trying to open port 5432 multiple times. This appeared to relate to IPv6; evidently, PostgreSQL would try to open up a socket on both the IPv4 and IPv6 addresses, and this somehow conflicted. Interestingly, 'localhost' would also fall prey to this; evidently that can be multiply interpreted in both IPv4 and IPv6. ' We had no difficulties when we set up a list of specific IPv4 addresses... -- select 'cbbrowne' || '@' || 'cbbrowne.com'; http://cbbrowne.com/info/internet.html When ever in doubt consult a song. --JT Fletcher