postgres - sharing same pg_hba.conf between IPV4 system and IPV6 system

Posted by StackTrace on Server Fault See other posts from Server Fault or by StackTrace
Published on 2010-11-01T06:41:30Z Indexed on 2011/02/19 7:26 UTC
Read the original article Hit count: 446

Filed under:
|
|
|

I am trying to package postgres from one machine to another. The source is windows 7 with IP V6 and target is windows XP with IPv4.

Starting postgres on windows XP gives error

2010-11-01 12:01:07 IST LOG:  invalid IP address "::1": Unknown host
2010-11-01 12:01:07 IST CONTEXT:  line 76 of configuration file "C:/postgres/data/pg_hba.conf"
2010-11-01 12:01:07 IST FATAL:  could not load pg_hba.conf

-- postgres - sharing same pg_hba.conf between IpV4 system and IpV6 system

Here is how my pg_hba.conf looks like

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# IPv4 local connections:
host    all         all         127.0.0.1/32          trust
# IPv6 local connections:
host    all         all         ::1/128               trust

© Server Fault or respective owner

Related posts about Windows

Related posts about postgresql