[BUGS] in hot standby database execute select * from pg_class indicate error
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! thanks! -- View this message in context: http://postgresql.1045698.n5.nabble.com/in-hot-standby-database-execute-select-from-pg-class-indicate-error-tp5699182.html Sent from the PostgreSQL - bugs mailing list archive at Nabble.com. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
Re: [BUGS] in hot standby database execute select * from pg_class indicate error
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