pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kevin Kempter <kevin@kevinkempterllc.com>
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
Message-ID: <200709121123.38968.kevin@kevinkempterllc.com> (raw)
In-Reply-To: <685903.26955.qm@web56414.mail.re3.yahoo.com>
References: <685903.26955.qm@web56414.mail.re3.yahoo.com>

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



view thread (3+ messages)  latest in thread

Message-ID: <200709121123.38968.kevin@kevinkempterllc.com>
Permalink:  ../200709121123.38968.kevin@kevinkempterllc.com/
Also on:    postgresql.org/message-id/200709121123.38968.kevin@kevinkempterllc.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: kevin@kevinkempterllc.com
  Subject: Re: how to change the port number for the Postgres server
  In-Reply-To: <200709121123.38968.kevin@kevinkempterllc.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox