Postgres Pro
Downloads
Home   >   mailing lists

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

From leo xu
Subject in hot standby database execute select * from pg_class indicate error
Date
Msg-id 1336628513527-5699182.post@n5.nabble.com
Whole thread Raw
Responses Re: in hot standby database execute select * from pg_class indicate error  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-bugs
Tree view 
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=EF=BC=9A9.1.2=20
 machine is :linux 5.4 64bit.
i know that i can recreate standby database,it can work.
is there  others ways!
thanks!

=20=20=20

--
View this message in context: http://postgresql.1045698.n5.nabble.com/in-ho=
t-standby-database-execute-select-from-pg-class-indicate-error-tp5699182.ht=
ml
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #6634: pg_dump dumps cast after objects depending on it
Next
From: Simon Riggs
Date:
Subject: Re: in hot standby database execute select * from pg_class indicate error