Skip site navigation (1) Skip section navigation (2)

Re: default port number

From: "Tena Sakai" <tsakai(at)gallo(dot)ucsf(dot)edu>
To: "Kevin Kempter" <kevin(at)kevinkempterllc(dot)com>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: default port number
Date: 2007-09-04 18:06:29
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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?


Tena Sakai

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org on behalf of Kevin Kempter
Sent: Tue 9/4/2007 10:09 AM
To: pgsql-admin(at)postgresql(dot)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(at)gallo(dot)ucsf(dot)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 ;


---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at


In response to


pgsql-admin by date

Next:From: Kevin KempterDate: 2007-09-04 18:08:53
Subject: Re: default port number
Previous:From: Kevin KempterDate: 2007-09-04 17:09:41
Subject: Re: default port number

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group