Tuesday, April 8, 2014

[PostgreSQL] Server fails to start on Windows 8

Recently stumbled on this problem. We have just upgraded all systems to Windows 8 in my office. The newly installed PostgreSQL was not starting. In PGAdminIII it would ask for password. But fail to proceed further.

On going through logs I came to see this error:

2014-04-08 15:00:10 IST FATAL:  no pg_hba.conf entry for host "::1", user "postgres", database "postgres", SSL off

So after un-commenting the line for IPv6 in pg_hba.conf, and restarting the server, it all started working fine.

The line is :
host     all     all     ::1/128     md5

Interesting point is it used to work fine on Win XP. Maybe Windows 8 has some special handling for IPv6. Don't know.

No comments:

Post a Comment