Re: in hot standby database execute select * from pg_class indicate error

On 10 May 2012 06:41, leo xu <leoxu8703(at)gmail(dot)com> wrote:
> hello:
>   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,
>  i connect to primary server,i can execute any operation.
>  standby connects to primary using streaming replication,it has
> synchronous.
>  my database server is：9.1.2
>  machine is :linux 5.4 64bit.
> i know that i can recreate standby database,it can work.
> is there  others ways!

Run REINDEX on the primary server.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services