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: <WernerBohl(at)infutor(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: TCP/IP access in Postgresql 8 Windows
Date: 2004-09-29 15:40:33
Message-ID: D5DB5D0D27171247AFEC9648EE98752F03220149@KCEX2KV1.mri-kc.int (view raw or flat)
Thread:
Lists: 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(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Werner Bohl
Sent: Wednesday, September 29, 2004 10:30 AM
To: pgsql-admin(at)postgresql(dot)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(at)infutor(dot)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(at)postgresql(dot)org so that your
      message can get through to the mailing list cleanly

pgsql-admin by date

Next:From: Magnus HaganderDate: 2004-09-29 15:52:22
Subject: Re: TCP/IP access in Postgresql 8 Windows
Previous:From: Werner BohlDate: 2004-09-29 15:30:18
Subject: TCP/IP access in Postgresql 8 Windows

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