On Tue, Jun 1, 2010 at 7:55 AM, Fredy Ganga (GMAIL ACCOUNT)
<fredy.ganga@gmail.com> wrote:
> 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.
Looks like it's trying to use IPv6 and there's no entries for IPv6 in
your pg_hba.conf to math.