Thank you, Kevin Kempter.
Thank you, Kevin Grittner,
In order for me to accept foreign odbc connection,
one of the things I must to is to change
listen_addresses = 'localhost'
to something like:
listen_addresses = 'ip-address-A, ip-address-B'
But those machines on the list are dhcp clients
and their ip addresses change from time to time.
Is there something I can do to accomodate such
moving targets?
Regards,
Tena Sakai
tsakai@gallo.ucsf.edu
-----Original Message-----
From: pgsql-admin-owner@postgresql.org on behalf of Kevin Kempter
Sent: Tue 9/4/2007 10:09 AM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] default port number
On Tuesday 04 September 2007 10:59:38 Tena Sakai wrote:
> Hi Everybody,
>
> I had been running postgres with postgresql.conf file
> as little changed as possible from distributed version.
> And lately I became a bit curious as well as confused.
>
> In my configuration file both lines
> #listen_addresses = 'localhost'
> and
> #port = 5432
> are commented out.
>
> What does this mean? Is postgress listening on port
> 5432?
>
> Regards,
>
> Tena Sakai
> tsakai@gallo.ucsf.edu
The above values are the defaults, postgres should be listening on port 5432
and only listening on localhost for connections. You can double check by
running these commands in a psql session:
show listen_addresses ;
show port ;
/Kevin
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate