On Tue, Jun 1, 2010 at 7:55 AM, Fredy Ganga (GMAIL ACCOUNT) <fredy.ganga@xxxxxxxxx> 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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
