Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 708619F98F7 for ; Wed, 12 Sep 2007 14:35:20 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 67075-02 for ; Wed, 12 Sep 2007 14:35:15 -0300 (ADT) X-Greylist: delayed 00:06:43.078736 by SQLgrey-1.7.5 Received: from outbound-mail-77.bluehost.com (outbound-mail-77.bluehost.com [69.89.22.26]) by postgresql.org (Postfix) with SMTP id 384819F97B5 for ; Wed, 12 Sep 2007 14:35:15 -0300 (ADT) Received: (qmail 10801 invoked by uid 0); 12 Sep 2007 17:28:30 -0000 Received: from unknown (HELO box54.bluehost.com) (69.89.20.54) by mailproxy4.bluehost.com with SMTP; 12 Sep 2007 17:28:30 -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 1IVW0q-0003x0-Pn for pgsql-admin@postgresql.org; Wed, 12 Sep 2007 11:28:29 -0600 From: Kevin Kempter To: pgsql-admin@postgresql.org Subject: Re: how to change the port number for the Postgres server Date: Wed, 12 Sep 2007 11:23:37 -0600 User-Agent: KMail/1.9.7 References: <685903.26955.qm@web56414.mail.re3.yahoo.com> In-Reply-To: <685903.26955.qm@web56414.mail.re3.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200709121123.38968.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-Archive-Number: 200709/82 X-Sequence-Number: 26843 On Wednesday 12 September 2007 11:10:51 Jessica Richard wrote: > Everything was running fine under the default number 5432. After the port > number was changed to another number in postresql.conf file and the server > was restarted, dblink is broken, it is still looking for the old port > number 5432... not sure if everything else is broken as well... > > So, how to change the port number cleanly? There other Postgis components > on the system too. > > Thanks, > Jessica > > > --------------------------------- > Need a vacation? Get great deals to amazing places on Yahoo! Travel. Not sure if this is a full fix per dblink but you might try setting this in the postgres .bashrc or .profile (or even in /etc/profile) export PGPORT=5555 # of course change 5555 to your new port number /Kevin