Received: from localhost (unknown [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 40F7E9FA530 for ; Wed, 12 Sep 2007 14:10:59 -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 61375-02-2 for ; Wed, 12 Sep 2007 14:10:53 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from web56414.mail.re3.yahoo.com (web56414.mail.re3.yahoo.com [216.252.111.93]) by postgresql.org (Postfix) with SMTP id BB4E99FA543 for ; Wed, 12 Sep 2007 14:10:52 -0300 (ADT) Received: (qmail 28388 invoked by uid 60001); 12 Sep 2007 17:10:51 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=U+O0AhAMT2Rwkbd+8rbdi5fP5Dr2MTvqRgBc0LiNq3tOh5fByHij2YmFNRwvRbMPyCR4qaiZ4X9iNEkrKKsYxECLHFeRy+4PVAqpE9JcU2Z/9rjV/HGIYLSDveZ/MJtITTs5NNunfT/0Tkr2djgb53IUdnymbbohr2hpk+qP8po=; X-YMail-OSG: sisPojEVM1mb.vADFV9zLGY2ey9jtmKUMR8GNw4apSmS33f8IhW4nlNTNpMpwA9D_ZcqTjTuAC2glZ3O2KxmnW4FyixTQzHUVTLi Received: from [198.119.134.32] by web56414.mail.re3.yahoo.com via HTTP; Wed, 12 Sep 2007 10:10:51 PDT Date: Wed, 12 Sep 2007 10:10:51 -0700 (PDT) From: Jessica Richard Subject: how to change the port number for the Postgres server To: pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-1747909446-1189617051=:26955" Content-Transfer-Encoding: 8bit Message-ID: <685903.26955.qm@web56414.mail.re3.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/80 X-Sequence-Number: 26841 --0-1747909446-1189617051=:26955 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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. --0-1747909446-1189617051=:26955 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit 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. --0-1747909446-1189617051=:26955--