in hot standby database execute select * from pg_class indicate error

From: leo xu <leoxu8703(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: in hot standby database execute select * from pg_class indicate error
Date: 2012-05-10 05:41:53
Message-ID: 1336628513527-5699182.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2012-05-10 06:14:36 Re: BUG #6634: pg_dump dumps cast after objects depending on it
Previous Message kurosawa-akira 2012-05-10 05:32:40 BUG #6635: TRUNCATE didn't recreate init fork.