pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
default port number
8+ messages / 3 participants
[nested] [flat]

* default port number
@ 2007-09-04 16:59 Tena Sakai <tsakai@gallo.ucsf.edu>
  2007-09-04 17:08 ` Re: default port number Kevin Grittner <Kevin.Grittner@wicourts.gov>
  2007-09-04 17:09 ` Re: default port number Kevin Kempter <kevin@kevinkempterllc.com>
  0 siblings, 2 replies; 8+ messages in thread

From: Tena Sakai @ 2007-09-04 16:59 UTC (permalink / raw)
  To: pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: default port number
  2007-09-04 16:59 default port number Tena Sakai <tsakai@gallo.ucsf.edu>
@ 2007-09-04 17:08 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
  1 sibling, 0 replies; 8+ messages in thread

From: Kevin Grittner @ 2007-09-04 17:08 UTC (permalink / raw)
  To: Tena Sakai <tsakai@gallo.ucsf.edu>; pgsql-admin

>>> On Tue, Sep 4, 2007 at 11:59 AM, in message
<FE44E0D7EAD2ED4BB2165071DB8E328C03062BBA@egcrc-ex01.egcrc.org>, "Tena Sakai"
<tsakai@gallo.ucsf.edu> wrote: 
> 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?
 
Yes.  Lines in postgresql.conf which are commented out generally show
the default.
 
-Kevin
 





^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: default port number
  2007-09-04 16:59 default port number Tena Sakai <tsakai@gallo.ucsf.edu>
@ 2007-09-04 17:09 ` Kevin Kempter <kevin@kevinkempterllc.com>
  2007-09-04 18:06   ` Re: default port number Tena Sakai <tsakai@gallo.ucsf.edu>
  1 sibling, 1 reply; 8+ messages in thread

From: Kevin Kempter @ 2007-09-04 17:09 UTC (permalink / raw)
  To: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: default port number
  2007-09-04 16:59 default port number Tena Sakai <tsakai@gallo.ucsf.edu>
  2007-09-04 17:09 ` Re: default port number Kevin Kempter <kevin@kevinkempterllc.com>
@ 2007-09-04 18:06   ` Tena Sakai <tsakai@gallo.ucsf.edu>
  2007-09-04 18:08     ` Re: default port number Kevin Kempter <kevin@kevinkempterllc.com>
  0 siblings, 1 reply; 8+ messages in thread

From: Tena Sakai @ 2007-09-04 18:06 UTC (permalink / raw)
  To: Kevin Kempter <kevin@kevinkempterllc.com>; 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?

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

^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: default port number
  2007-09-04 16:59 default port number Tena Sakai <tsakai@gallo.ucsf.edu>
  2007-09-04 17:09 ` Re: default port number Kevin Kempter <kevin@kevinkempterllc.com>
  2007-09-04 18:06   ` Re: default port number Tena Sakai <tsakai@gallo.ucsf.edu>
@ 2007-09-04 18:08     ` Kevin Kempter <kevin@kevinkempterllc.com>
  2007-09-04 18:18       ` Re: default port number Tena Sakai <tsakai@gallo.ucsf.edu>
  0 siblings, 1 reply; 8+ messages in thread

From: Kevin Kempter @ 2007-09-04 18:08 UTC (permalink / raw)
  To: pgsql-admin

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





^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: default port number
  2007-09-04 16:59 default port number Tena Sakai <tsakai@gallo.ucsf.edu>
  2007-09-04 17:09 ` Re: default port number Kevin Kempter <kevin@kevinkempterllc.com>
  2007-09-04 18:06   ` Re: default port number Tena Sakai <tsakai@gallo.ucsf.edu>
  2007-09-04 18:08     ` Re: default port number Kevin Kempter <kevin@kevinkempterllc.com>
@ 2007-09-04 18:18       ` Tena Sakai <tsakai@gallo.ucsf.edu>
  2007-09-04 18:54         ` Re: default port number Kevin Grittner <Kevin.Grittner@wicourts.gov>
  0 siblings, 1 reply; 8+ messages in thread

From: Tena Sakai @ 2007-09-04 18:18 UTC (permalink / raw)
  To: Kevin Kempter <kevin@kevinkempterllc.com>; pgsql-admin

Many thanks, Kevin.

'*' is a bit too wide for my taste.  I wonder
if it is possible to specify something like
network mask (or range)?  I may be a bit
paranoid, but...

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 11:08 AM
To: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] default port number
 
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



---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly

^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: default port number
  2007-09-04 16:59 default port number Tena Sakai <tsakai@gallo.ucsf.edu>
  2007-09-04 17:09 ` Re: default port number Kevin Kempter <kevin@kevinkempterllc.com>
  2007-09-04 18:06   ` Re: default port number Tena Sakai <tsakai@gallo.ucsf.edu>
  2007-09-04 18:08     ` Re: default port number Kevin Kempter <kevin@kevinkempterllc.com>
  2007-09-04 18:18       ` Re: default port number Tena Sakai <tsakai@gallo.ucsf.edu>
@ 2007-09-04 18:54         ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
  2007-09-04 19:16           ` Re: default port number Tena Sakai <tsakai@gallo.ucsf.edu>
  0 siblings, 1 reply; 8+ messages in thread

From: Kevin Grittner @ 2007-09-04 18:54 UTC (permalink / raw)
  To: Tena Sakai <tsakai@gallo.ucsf.edu>; Kevin Kempter <kevin@kevinkempterllc.com>; pgsql-admin

>>> On Tue, Sep 4, 2007 at  1:18 PM, in message
<FE44E0D7EAD2ED4BB2165071DB8E328C03062BBD@egcrc-ex01.egcrc.org>, "Tena Sakai"
<tsakai@gallo.ucsf.edu> wrote: 
> '*' is a bit too wide for my taste.  I wonder
> if it is possible to specify something like
> network mask (or range)?
 
This is not the IP list you will listen *to*, but the IP list you will
listen *on*.  (You may have multiple network adapters and not want to
accept connections on all of them.)
 
To limit the IP addresses which can connect to the server, see the
pg_hba file.
 
-Kevin
 





^ permalink  raw  reply  [nested|flat] 8+ messages in thread

* Re: default port number
  2007-09-04 16:59 default port number Tena Sakai <tsakai@gallo.ucsf.edu>
  2007-09-04 17:09 ` Re: default port number Kevin Kempter <kevin@kevinkempterllc.com>
  2007-09-04 18:06   ` Re: default port number Tena Sakai <tsakai@gallo.ucsf.edu>
  2007-09-04 18:08     ` Re: default port number Kevin Kempter <kevin@kevinkempterllc.com>
  2007-09-04 18:18       ` Re: default port number Tena Sakai <tsakai@gallo.ucsf.edu>
  2007-09-04 18:54         ` Re: default port number Kevin Grittner <Kevin.Grittner@wicourts.gov>
@ 2007-09-04 19:16           ` Tena Sakai <tsakai@gallo.ucsf.edu>
  0 siblings, 0 replies; 8+ messages in thread

From: Tena Sakai @ 2007-09-04 19:16 UTC (permalink / raw)
  To: Kevin Grittner <Kevin.Grittner@wicourts.gov>; Kevin Kempter <kevin@kevinkempterllc.com>; pgsql-admin

Hi Kevin.

I had to read your message twice and look at
pg_hba.conf file, but I am now clear.  Yes,
a big difference between listen *on* and
listen *to*.

Many thanks.

Tena Sakai
tsakai@gallo.ucsf.edu


-----Original Message-----
From: Kevin Grittner [mailto:Kevin.Grittner@wicourts.gov]
Sent: Tue 9/4/2007 11:54 AM
To: Tena Sakai; Kevin Kempter; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] default port number
 
>>> On Tue, Sep 4, 2007 at  1:18 PM, in message
<FE44E0D7EAD2ED4BB2165071DB8E328C03062BBD@egcrc-ex01.egcrc.org>, "Tena Sakai"
<tsakai@gallo.ucsf.edu> wrote: 
> '*' is a bit too wide for my taste.  I wonder
> if it is possible to specify something like
> network mask (or range)?
 
This is not the IP list you will listen *to*, but the IP list you will
listen *on*.  (You may have multiple network adapters and not want to
accept connections on all of them.)
 
To limit the IP addresses which can connect to the server, see the
pg_hba file.
 
-Kevin
 

^ permalink  raw  reply  [nested|flat] 8+ messages in thread


end of thread, other threads:[~2007-09-04 19:16 UTC | newest]

Thread overview: 8+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-09-04 16:59 default port number Tena Sakai <tsakai@gallo.ucsf.edu>
2007-09-04 17:08 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2007-09-04 17:09 ` Kevin Kempter <kevin@kevinkempterllc.com>
2007-09-04 18:06   ` Tena Sakai <tsakai@gallo.ucsf.edu>
2007-09-04 18:08     ` Kevin Kempter <kevin@kevinkempterllc.com>
2007-09-04 18:18       ` Tena Sakai <tsakai@gallo.ucsf.edu>
2007-09-04 18:54         ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2007-09-04 19:16           ` Tena Sakai <tsakai@gallo.ucsf.edu>

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