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
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) |