pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kevin Kempter <kevin@kevinkempterllc.com>
To: pgsql-admin@postgresql.org
Subject: Re: default port number
Date: Tue, 4 Sep 2007 12:08:53 -0600
Message-ID: <200709041208.53976.kevin@kevinkempterllc.com> (raw)
In-Reply-To: <FE44E0D7EAD2ED4BB2165071DB8E328C03062BBC@egcrc-ex01.egcrc.org>
References: <FE44E0D7EAD2ED4BB2165071DB8E328C03062BBA@egcrc-ex01.egcrc.org>
	<200709041109.42925.kevin@kevinkempterllc.com>
	<FE44E0D7EAD2ED4BB2165071DB8E328C03062BBC@egcrc-ex01.egcrc.org>

On Tuesday 04 September 2007 12:06:29 Tena Sakai wrote:
> 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?


You can use hostnames instead of I.P.'s or you can set:

listen_addresses = '*'

Note that just because postgres will listen to all hosts ('*') the actual 
authentication access is controlled by pg_hba.conf 

 
>
> 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





view thread (8+ messages)  latest in thread

Message-ID: <200709041208.53976.kevin@kevinkempterllc.com>
Permalink:  ../200709041208.53976.kevin@kevinkempterllc.com/
Also on:    postgresql.org/message-id/200709041208.53976.kevin@kevinkempterllc.com

 · 

reply

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: kevin@kevinkempterllc.com
  Subject: Re: default port number
  In-Reply-To: <200709041208.53976.kevin@kevinkempterllc.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