Vista SP1 -> PostgreSQL won't start

[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?

[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.

[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...