FATAL: pg_hba.conf ::1
| От | Fredy Ganga (GMAIL ACCOUNT) |
|---|---|
| Тема | FATAL: pg_hba.conf ::1 |
| Дата | |
| Msg-id | AANLkTimGbscQ0GZKNez6lqF_dINfA4ouBxXm2F0uD6Zk@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: FATAL: pg_hba.conf ::1
|
| Список | 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
В списке pgsql-admin по дате отправления: