The following bug has been logged online:

Bug reference: 1372
Logged by: Graham Robson
Email address: graham.robson (AT) coherencedesign (DOT) co.uk
PostgreSQL version: 8.0
Operating system: Windows XP SP2
Description: Service won't start with tcpip_socket = true
Details:

Trying to setup TCP/IP access over my network. The supplied postgresql.conf
has no commented reference to the setting tcpip_socket = true.

Adding this in stops the service from starting i.e. this reference directly
stops the service from starting.

An appropriate entry defining the IP_ADDRESS in the pg_hba.conf

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Please check your postgresql logs. If they contain an error about shared
memory witgh "Invalid argument", you have hit a known bug in <=3D RC3
versions. This is (supposed to be) fixed in RC3.

If you're installing from the MSI, there is no MSI installer for RC3 yet
(sorry about that), but we expect to put one out in the next couple of
days. If you're gonig from source, try to just upgrade your version.
Finally, if you're going from the MSI, there is an *ugly* workaronud
downloadable from http://www.hagander.net/pgsql/postgres_shmem.zip.
Replace your postgres.exe from this file, and then copy postgres.exe
over postmaster.exe (they should be identical). I wouldn't recommend
this solution for long, but if you're still in a testing environment it
might be worth a try while waiting for RC3.

//Magnus

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

On Tue, 4 Jan 2005, Graham Robson wrote:

8.0 has replaced the tcpip_socket flag with the listen_addresses setting
which specifies which addresses to listen on.

Kris Jurka

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org