From: Joe Conway <mail@joeconway.com>
To: Jessica Richard <rjessil@yahoo.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: how to change the port number for the Postgres server
Date: Wed, 12 Sep 2007 10:34:58 -0700
Message-ID: <46E82342.4030808@joeconway.com> (raw)
In-Reply-To: <685903.26955.qm@web56414.mail.re3.yahoo.com>
References: <685903.26955.qm@web56414.mail.re3.yahoo.com>
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.htmlhttp://www.postgresql.org/docs/8.2/interactive/libpq-connect.html
HTH,
Joe
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: mail@joeconway.com, rjessil@yahoo.com
Subject: Re: how to change the port number for the Postgres server
In-Reply-To: <46E82342.4030808@joeconway.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