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
