Re: how to change the port number for the Postgres server - Mailing list pgsql-admin

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