FATAL: pg_hba.conf ::1

From: "Fredy Ganga (GMAIL ACCOUNT)" <fredy(dot)ganga(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: FATAL: pg_hba.conf ::1
Date: 2010-06-01 13:55:44
Message-ID: AANLkTimGbscQ0GZKNez6lqF_dINfA4ouBxXm2F0uD6Zk@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello:

I have been testing streaming replication on postgresql 9, and now i have
this messages in pg_log on salve.

pg_log:
2010-06-01 09:13:58 CLT LOG: el sistema de bases de datos fue interrumpido;
última vez en funcionamiento en 2010-06-01 09:00:17 CLT
2010-06-01 09:13:58 CLT LOG: entering standby mode
2010-06-01 09:13:58 CLT LOG: redo comienza en 0/10000020
2010-06-01 09:13:58 CLT LOG: registro de longitud cero en 0/100000A8
2010-06-01 09:13:58 CLT LOG: streaming replication successfully connected
to primary
2010-06-01 09:13:59 CLT FATAL: el sistema de base de datos está iniciándose
2010-06-01 09:14:00 CLT FATAL: el sistema de base de datos está iniciándose
2010-06-01 09:14:00 CLT LOG: consistent recovery state reached at
0/11000000
2010-06-01 09:14:00 CLT LOG: database system is ready to accept read only
connections
*2010-06-01 09:14:01 CLT FATAL: no hay una línea en pg_hba.conf para «::1»,
usuario «postgres», base de datos «postgres», SSL inactivo*
*2010-06-01 09:14:02 CLT FATAL: no hay una línea en pg_hba.conf para «::1»,
usuario «postgres», base de datos «postgres», SSL inactivo*

IPV6????

My pg_hba on slave:
# TYPE DATABASE USER CIDR-ADDRESS METHOD

# IPv4 local connections:
host all all 127.0.0.1/32 md5
#host replication postgres 192.168.XXX.XX/16 trust
host all all 192.168.XXX.XX/16 trust
# IPv6 local connections:
#host all all ::1/128 md5

ENVIRONMENT:
DB: Postgresql 9
Master: Windows XP
Slave: Windows 2008 Server

Maybe this problem is'nt important to the replication process.. but... i
would like to resolve it...

Thanks for your help.

Fredy

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Daniel, Clyde D (Derrick) 2010-06-01 16:01:31 Installing PostgreSQL
Previous Message Dale Gallagher 2010-06-01 11:17:03 Re: Strange behaviour: create database hangs (v 8.4.4)