Re: in hot standby database execute select * from pg_class indicate error - Mailing list pgsql-bugs

On 10 May 2012 06:41, leo xu <leoxu8703@gmail.com> wrote:
> hello:
> =C2=A0 i execute any operation in hot standby database,it indicates that =
index
> pg_class_relname_nsp_index contains unexpected zero page at block 0,please
> reindex it.but hot standby server ,it only allow read,not write,
> =C2=A0i connect to primary server,i can execute any operation.
> =C2=A0standby connects to primary using streaming replication,it has
> synchronous.
> =C2=A0my database server is=EF=BC=9A9.1.2
> =C2=A0machine is :linux 5.4 64bit.
> i know that i can recreate standby database,it can work.
> is there =C2=A0others ways!

Run REINDEX on the primary server.

--=20
=C2=A0Simon Riggs=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=
=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0=C2=A0 http://www.2ndQuadrant.=
com/
=C2=A0PostgreSQL Development, 24x7 Support, Training & Services