Vista SP1 -> PostgreSQL won't start
Posted:
Fri Mar 21, 2008 5:14 amby Zeatrix
Installed Vista Service Pack 1 last night and realized this morning that PostgreSQL won't start now. Tried uninstalling PostgreSQL and installed version 8.2.7 but it did not help. Also re-created the PostreSQL windows user account.
Anyone have some suggestions?
Re: Vista SP1 -> PostgreSQL won't start
Posted:
Fri Mar 21, 2008 8:54 amby ptrack pat
Go to the c:\program files\postgresql\8.2\data folder. Is there a file called postmaster.pid there? If so, delete it then restart the computer and try it again.
Re: Vista SP1 -> PostgreSQL won't start
Posted:
Fri Mar 21, 2008 9:00 amby Zeatrix
Good suggestion, it was ONE of the problems.
However, after spending 2-3 hours looking for the cause I finally, by chance, found it. When installing Windows Vista Service Pack 1 it seems this line is added to the "hosts" file in C:\windows\system32\drivers\etc
::1 localhost
This makes a call to localhost use the IPv6 adress instead of the IPv4 (127.0.0.1)
For some reason (I can't remember) I have this set in my pg_hba file:
# IPv6 local connections:
host all all ::1/128 trust
If set to md5 instead of trust it works.
Man, this took a LONG time to figure out...
