Обсуждение: how to change the port number for the Postgres server

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.

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.

postgresql.conf only affects the server. dblink is a client.

Either set PGPORT environment variable, or explicitly call out the port
number you want as part of the libpg connection string. See:

http://www.postgresql.org/docs/8.2/interactive/libpq-envars.html
http://www.postgresql.org/docs/8.2/interactive/libpq-connect.html

HTH,

Joe

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