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
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
