--0016e6d7ef85634bc70487f854a9
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
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=
;
=FAltima 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=E1 inici=E1=
ndose
2010-06-01 09:14:00 CLT FATAL: el sistema de base de datos est=E1 inici=E1=
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=EDnea en pg_hba.conf para =AB=
::1=BB,
usuario =ABpostgres=BB, base de datos =ABpostgres=BB, SSL inactivo*
*2010-06-01 09:14:02 CLT FATAL: no hay una l=EDnea en pg_hba.conf para =AB=
::1=BB,
usuario =ABpostgres=BB, base de datos =ABpostgres=BB, 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
--0016e6d7ef85634bc70487f854a9
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Hello:<div><br></div><div><br></div><div>I have been testing streaming repl=
ication on postgresql 9, and now i have this messages in pg_log on salve.</=
div><div><br></div><div>pg_log:</div><div><div><div>2010-06-01 09:13:58 CLT=
LOG: =A0el sistema de bases de datos fue interrumpido; =FAltima vez en fun=
cionamiento en 2010-06-01 09:00:17 CLT</div>
<div>2010-06-01 09:13:58 CLT LOG: =A0entering standby mode</div><div>2010-0=
6-01 09:13:58 CLT LOG: =A0redo comienza en 0/10000020</div><div>2010-06-01 =
09:13:58 CLT LOG: =A0registro de longitud cero en 0/100000A8</div><div>2010=
-06-01 09:13:58 CLT LOG: =A0streaming replication successfully connected to=
primary</div>
<div>2010-06-01 09:13:59 CLT FATAL: =A0el sistema de base de datos est=E1 i=
nici=E1ndose</div><div>2010-06-01 09:14:00 CLT FATAL: =A0el sistema de base=
de datos est=E1 inici=E1ndose</div><div>2010-06-01 09:14:00 CLT LOG: =A0co=
nsistent recovery state reached at 0/11000000</div>
<div>2010-06-01 09:14:00 CLT LOG: =A0database system is ready to accept rea=
d only connections</div><div><b><u>2010-06-01 09:14:01 CLT FATAL: =A0no hay=
una l=EDnea en pg_hba.conf para =AB::1=BB, usuario =ABpostgres=BB, base de=
datos =ABpostgres=BB, SSL inactivo</u></b></div>
<div><b><u>2010-06-01 09:14:02 CLT FATAL: =A0no hay una l=EDnea en pg_hba.c=
onf para =AB::1=BB, usuario =ABpostgres=BB, base de datos =ABpostgres=BB, S=
SL inactivo</u></b></div></div></div><div><br></div><div><br></div><div>IPV=
6????</div><div>
<br></div><div>My pg_hba on slave:</div><div><div># TYPE =A0DATABASE =A0 =
=A0 =A0 =A0USER =A0 =A0 =A0 =A0 =A0 =A0CIDR-ADDRESS =A0 =A0 =A0 =A0 =A0 =A0=
METHOD</div><div><br></div><div># IPv4 local connections:</div><div>host =
=A0 =A0all =A0 =A0 =A0 =A0 =A0 =A0 all =A0 =A0 =A0 =A0 =A0 =A0 <a href=3D"h=
ttp://127.0.0.1/32">127.0.0.1/32</a> =A0 =A0 =A0 =A0 =A0 =A0md5</div>
<div>#host<span class=3D"Apple-tab-span" style=3D"white-space:pre"> </span>=
replication<span class=3D"Apple-tab-span" style=3D"white-space:pre"> </span=
>postgres<span class=3D"Apple-tab-span" style=3D"white-space:pre"> </span>=
192.168.XXX.XX/16<span class=3D"Apple-tab-span" style=3D"white-space:pre"> =
</span>trust</div>
<div>host<span class=3D"Apple-tab-span" style=3D"white-space:pre"> </span>a=
ll<span class=3D"Apple-tab-span" style=3D"white-space:pre"> </span>all<span=
class=3D"Apple-tab-span" style=3D"white-space:pre"> </span>192.168.XXX.XX=
/16<span class=3D"Apple-tab-span" style=3D"white-space:pre"> </span>trust<=
/div>
<div># IPv6 local connections:</div><div>#host =A0 =A0all =A0 =A0 =A0 =A0 =
=A0 =A0 all =A0 =A0 =A0 =A0 =A0 =A0 ::1/128 =A0 =A0 =A0 =A0 =A0 =A0 =A0 =A0=
md5</div></div><div><br></div><div>ENVIRONMENT:</div><div>DB: Postgresql 9=
</div><div>Master: Windows XP</div><div>Slave: Windows 2008 Server=A0</div>
<div><br></div><div>Maybe this problem is'nt important to the replicati=
on process.. but... i would like to resolve it...</div><div><br></div><div>=
Thanks for your help.</div><div><br></div><div><br></div><div>Fredy</div>
<div><br></div><div><br></div><div><br></div>
--0016e6d7ef85634bc70487f854a9--
