Windows – Problems with installing a postgres server on a windows machine

postgresqlwindows

I have tried to install a postgres on my windows Vista, but I cannot seem to get it to work.

I download PGAdmin tools and when i try to connect to localhost it tells me the generic thing that the connection was refused.

I enabled listen on all ip addresses, and local authentication set to 'trust'

I am not sure how to check if the server is actually running
the user name is still postgres even on windows I assume.

I have no clue what tool i can use or what process I should look for.

There is postgresql-9.1 service, which is not running, and when I try to start it, it tells me
"The postgresql-9.1 service on Local Computer started and then stopped. Some services stop automatically if they are not in use by other services or programs."

I am out of ideas, can anyone help?

PS. below is my pg_hba file

#IPv4 local connections:
host     all     all     192.168.0.1/16  trust
#IPv6 local connections:
host     all     all     *   trust
host     all     postgres    192.168.0.1/16  md5
host     all     postgres    ::1/128     md5
local    all     all     trust

PPS. this is what the error log says:

011-11-20 21:58:07 EST LOG:  local connections are not supported by this build
2011-11-20 21:58:07 EST CONTEXT:  line 87 of configuration file "C:/Program Files/PostgreSQL/9.1/data/pg_hba.conf"
2011-11-20 21:58:07 EST FATAL:  could not load pg_hba.conf

Best Answer

At a guess, you should look at line 87 (like the error message says) and you'll probably find that's the "local all all" line. As the error message tells you "local" connections are not supported.

The "local" connection type is for unix sockets, not tcp sockets, and Windows doesn't support them.

Related Topic