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

Re: TCP/IP access in Postgresql 8 Windows

From: "Bender, Cheryl" <cbender(at)mriresearch(dot)org>
To: "Magnus Hagander" <mha(at)sollentuna(dot)net>, <WernerBohl(at)infutor(dot)com>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: TCP/IP access in Postgresql 8 Windows
Date: 2004-09-29 16:01:19
Message-ID: D5DB5D0D27171247AFEC9648EE98752F04454AA5@KCEX2KV1.mri-kc.int (view raw or flat)
Thread:
Lists: 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(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Magnus Hagander
Sent: Wednesday, September 29, 2004 10:52 AM
To: WernerBohl(at)infutor(dot)com; pgsql-admin(at)postgresql(dot)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

pgsql-admin by date

Next:From: Magnus HaganderDate: 2004-09-29 16:04:33
Subject: Re: TCP/IP access in Postgresql 8 Windows
Previous:From: Magnus HaganderDate: 2004-09-29 15:52:22
Subject: Re: TCP/IP access in Postgresql 8 Windows

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