Could not Start Server (could not create any TCP/IP sockets)

From: Ms swati chande <swativc(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Cc: swativc(at)yahoo(dot)com
Subject: Could not Start Server (could not create any TCP/IP sockets)
Date: 2009-07-12 19:03:34
Message-ID: 285976.67657.qm@web112611.mail.gq1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I built and installed Postgresql 8.4.0 from source using Visual Studio 2005 on Windows XP.
All build and installation steps executed successfully as mentioned in the Postgresql Documentation, but server could not be started.
Given below is the detail of the problem I am facing.

From user Postgres,
        initdb -D c:\postgresql\Data1
was run with success

and then
       pg_ctl -D c:\postgresql\Data1 start -l logfile

This reported the following entries in the logfile:
       LOG:  could not bind IPv4 socket: No error
       HINT:  Is another postmaster already running on port 5432? If not, wait a few seconds  and retry.
       WARNING:  could not create listen socket for "localhost"
       FATAL:  could not create any TCP/IP sockets

The file pg_hba.conf is as follows:
       # TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

       # IPv4 local connections:
       host    all         all         127.0.0.1/32          trust
       # IPv6 local connections:
       #host    all         all         ::1/128               trust

and postgresql.conf has the following:

       listen_addresses = 'localhost'          # what IP address(es) to listen on;
                                                           # comma-separated list of addresses;
                                                           # defaults to 'localhost', '*' = all
                                                           # (change requires restart)
       port = 5432                                   # (change requires restart)

I have also tried writing the host address (ipconfig) for listen_addresses and CIDR-address but it did not work.

Please help in identifying the problem.

Regards
Swati

Browse pgsql-general by date

  From Date Subject
Next Message Viktor Rosenfeld 2009-07-12 19:07:56 How can I find out the space used on disk for a table/index
Previous Message Simon Riggs 2009-07-12 18:36:24 Re: Checkpoint Tuning Question