On 10 May 2012 06:41, leo xu <leoxu8...@gmail.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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
