Обсуждение: default port number
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
>>> 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
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
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
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
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
>>> 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
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