pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedTCP/IP access in Postgresql 8 Windows
6+ messages / 3 participants
[nested] [flat]
* TCP/IP access in Postgresql 8 Windows
@ 2004-09-29 15:30 Werner Bohl <WernerBohl@infutor.com>
0 siblings, 0 replies; 6+ messages in thread
From: Werner Bohl @ 2004-09-29 15:30 UTC (permalink / raw)
To: pgsql-admin
Hi,
I'm pretty versed in Postgresql version 7.* on Linux. Need to setup a
8.* server on Windows. Postgresql 8 is rejecting TCP/IP connections.
Tried to acivate tcpip_sockets, as in the 7.4.* versions, configuring
postgresql.conf param tcpip_sockets, but it is not recognized by version
8 (it even fails to start if included). Client IP's have an entry in
pg_hba.conf.
Is there any other task that must be done in order to get TCP/IP
connections working?
TIA,
--
Werner Bohl <WernerBohl@infutor.com>
Infutor de Costa Rica S.A.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: TCP/IP access in Postgresql 8 Windows
@ 2004-09-29 15:40 Bender, Cheryl <cbender@mriresearch.org>
0 siblings, 0 replies; 6+ messages in thread
From: Bender, Cheryl @ 2004-09-29 15:40 UTC (permalink / raw)
To: WernerBohl@infutor.com; pgsql-admin
Werner;
Activating tcp/ip listening is different than 7.*. You need to
uncomment the following line in your postgresql.conf and change it to
listen on a specified interface or '*' for all interfaces.
Listen_addresses='*'
Then restart the service.
Another very useful parameter on Windows to change is to change the
log_destination to 'eventlog'. That way if the service does not start,
you can go to the event log and get some fairly detailed information
about what is wrong.
Cheryl Bender
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Werner Bohl
Sent: Wednesday, September 29, 2004 10:30 AM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] TCP/IP access in Postgresql 8 Windows
Hi,
I'm pretty versed in Postgresql version 7.* on Linux. Need to setup a
8.* server on Windows. Postgresql 8 is rejecting TCP/IP connections.
Tried to acivate tcpip_sockets, as in the 7.4.* versions, configuring
postgresql.conf param tcpip_sockets, but it is not recognized by version
8 (it even fails to start if included). Client IP's have an entry in
pg_hba.conf.
Is there any other task that must be done in order to get TCP/IP
connections working?
TIA,
--
Werner Bohl <WernerBohl@infutor.com>
Infutor de Costa Rica S.A.
---------------------------(end of broadcast)---------------------------
TIP 3: 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] 6+ messages in thread
* Re: TCP/IP access in Postgresql 8 Windows
@ 2004-09-29 15:52 Magnus Hagander <mha@sollentuna.net>
0 siblings, 0 replies; 6+ messages in thread
From: Magnus Hagander @ 2004-09-29 15:52 UTC (permalink / raw)
To: WernerBohl@infutor.com; pgsql-admin
> Hi,
>
> I'm pretty versed in Postgresql version 7.* on Linux. Need to setup a
> 8.* server on Windows. Postgresql 8 is rejecting TCP/IP connections.
> Tried to acivate tcpip_sockets, as in the 7.4.* versions,
> configuring postgresql.conf param tcpip_sockets, but it is
> not recognized by version
> 8 (it even fails to start if included). Client IP's have an
> entry in pg_hba.conf.
>
> Is there any other task that must be done in order to get
> TCP/IP connections working?
TCP/IP is enabled by default on Windows. Your problem is somewhere else
- check for local firewall or antivirus sofware that might be blocking
the connection.
tcpip_sockets has been renamed to listen_addresses. Check
http://developer.postgresql.org/docs/postgres/runtime-config.html#RUNTIM
E-CONFIG-CONNECTION.
//Magnus
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: TCP/IP access in Postgresql 8 Windows
@ 2004-09-29 16:01 Bender, Cheryl <cbender@mriresearch.org>
0 siblings, 0 replies; 6+ messages in thread
From: Bender, Cheryl @ 2004-09-29 16:01 UTC (permalink / raw)
To: Magnus Hagander <mha@sollentuna.net>; WernerBohl@infutor.com; pgsql-admin
<<TCP/IP is enabled by default on Windows. Your problem is somewhere
else>>
This is not bourne out by my experience or the document you referenced.
The document and postgresql.conf both state that the default is
'localhost' and only allows local loopback connections.
For some reason the author of postgresql.conf did not follow the
convention of putting the commented default setting in the conf file
(e.g. listen_addresses='localhost' instead of '*', so I think this leads
a lot of people to think that TCP/IP is enabled by default.
Cheryl Bender
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Magnus Hagander
Sent: Wednesday, September 29, 2004 10:52 AM
To: WernerBohl@infutor.com; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] TCP/IP access in Postgresql 8 Windows
> Hi,
>
> I'm pretty versed in Postgresql version 7.* on Linux. Need to setup a
> 8.* server on Windows. Postgresql 8 is rejecting TCP/IP connections.
> Tried to acivate tcpip_sockets, as in the 7.4.* versions, configuring
> postgresql.conf param tcpip_sockets, but it is not recognized by
> version 8 (it even fails to start if included). Client IP's have an
> entry in pg_hba.conf.
>
> Is there any other task that must be done in order to get
> TCP/IP connections working?
TCP/IP is enabled by default on Windows. Your problem is somewhere else
- check for local firewall or antivirus sofware that might be blocking
the connection.
tcpip_sockets has been renamed to listen_addresses. Check
http://developer.postgresql.org/docs/postgres/runtime-config.html#RUNTIM
E-CONFIG-CONNECTION.
//Magnus
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: TCP/IP access in Postgresql 8 Windows
@ 2004-09-29 16:04 Magnus Hagander <mha@sollentuna.net>
0 siblings, 0 replies; 6+ messages in thread
From: Magnus Hagander @ 2004-09-29 16:04 UTC (permalink / raw)
To: Bender, Cheryl <cbender@mriresearch.org>; WernerBohl@infutor.com; pgsql-admin
> <<TCP/IP is enabled by default on Windows. Your problem is somewhere
> else>>
> This is not bourne out by my experience or the document you
> referenced.
> The document and postgresql.conf both state that the default
> is 'localhost' and only allows local loopback connections.
Default is 'localhost'. This is TCP/IP. Which is different from Unix
sockets. Since Unix sockets aren't available on Windows, you need TCP/IP
to be able to connect at all.
That said, I think I may have misread the original question as actually
wanting "remote TCP/IP" connections. The comment about the clients IP
certainly implies so. In which case my answer was clearly wrong! Sorry
to mislead you :-)
//Magnus
> -----Original Message-----
> From: pgsql-admin-owner@postgresql.org
> [mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Magnus Hagander
> Sent: Wednesday, September 29, 2004 10:52 AM
> To: WernerBohl@infutor.com; pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] TCP/IP access in Postgresql 8 Windows
>
>
> > Hi,
> >
> > I'm pretty versed in Postgresql version 7.* on Linux. Need
> to setup a
> > 8.* server on Windows. Postgresql 8 is rejecting TCP/IP
> connections.
> > Tried to acivate tcpip_sockets, as in the 7.4.* versions,
> configuring
> > postgresql.conf param tcpip_sockets, but it is not recognized by
> > version 8 (it even fails to start if included). Client IP's have an
> > entry in pg_hba.conf.
> >
> > Is there any other task that must be done in order to get TCP/IP
> > connections working?
>
> TCP/IP is enabled by default on Windows. Your problem is
> somewhere else
> - check for local firewall or antivirus sofware that might be
> blocking the connection.
>
> tcpip_sockets has been renamed to listen_addresses. Check
> http://developer.postgresql.org/docs/postgres/runtime-config.h
> tml#RUNTIM
> E-CONFIG-CONNECTION.
>
>
> //Magnus
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: TCP/IP access in Postgresql 8 Windows
@ 2004-09-29 16:17 Bender, Cheryl <cbender@mriresearch.org>
0 siblings, 0 replies; 6+ messages in thread
From: Bender, Cheryl @ 2004-09-29 16:17 UTC (permalink / raw)
To: Bender, Cheryl <cbender@mriresearch.org>; Magnus Hagander <mha@sollentuna.net>; WernerBohl@infutor.com; pgsql-admin
Correction to my previous statement,
Remote tcp/ip connections on windows are not enabled by default, but
Magnus is right in that local connections are enabled by default. Sorry
for my mistatement.
Cheryl Bender
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Bender, Cheryl
Sent: Wednesday, September 29, 2004 11:01 AM
To: Magnus Hagander; WernerBohl@infutor.com; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] TCP/IP access in Postgresql 8 Windows
<<TCP/IP is enabled by default on Windows. Your problem is somewhere
else>>
This is not bourne out by my experience or the document you referenced.
The document and postgresql.conf both state that the default is
'localhost' and only allows local loopback connections.
For some reason the author of postgresql.conf did not follow the
convention of putting the commented default setting in the conf file
(e.g. listen_addresses='localhost' instead of '*', so I think this leads
a lot of people to think that TCP/IP is enabled by default.
Cheryl Bender
-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] On Behalf Of Magnus Hagander
Sent: Wednesday, September 29, 2004 10:52 AM
To: WernerBohl@infutor.com; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] TCP/IP access in Postgresql 8 Windows
> Hi,
>
> I'm pretty versed in Postgresql version 7.* on Linux. Need to setup a
> 8.* server on Windows. Postgresql 8 is rejecting TCP/IP connections.
> Tried to acivate tcpip_sockets, as in the 7.4.* versions, configuring
> postgresql.conf param tcpip_sockets, but it is not recognized by
> version 8 (it even fails to start if included). Client IP's have an
> entry in pg_hba.conf.
>
> Is there any other task that must be done in order to get TCP/IP
> connections working?
TCP/IP is enabled by default on Windows. Your problem is somewhere else
- check for local firewall or antivirus sofware that might be blocking
the connection.
tcpip_sockets has been renamed to listen_addresses. Check
http://developer.postgresql.org/docs/postgres/runtime-config.html#RUNTIM
E-CONFIG-CONNECTION.
//Magnus
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2004-09-29 16:17 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-09-29 15:30 TCP/IP access in Postgresql 8 Windows Werner Bohl <WernerBohl@infutor.com>
2004-09-29 15:40 Re: TCP/IP access in Postgresql 8 Windows Bender, Cheryl <cbender@mriresearch.org>
2004-09-29 15:52 Re: TCP/IP access in Postgresql 8 Windows Magnus Hagander <mha@sollentuna.net>
2004-09-29 16:01 Re: TCP/IP access in Postgresql 8 Windows Bender, Cheryl <cbender@mriresearch.org>
2004-09-29 16:04 Re: TCP/IP access in Postgresql 8 Windows Magnus Hagander <mha@sollentuna.net>
2004-09-29 16:17 Re: TCP/IP access in Postgresql 8 Windows Bender, Cheryl <cbender@mriresearch.org>
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