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