Lists: | pgsql-bugs |
---|
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 |
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.
From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
---|---|
To: | leo xu <leoxu8703(at)gmail(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: in hot standby database execute select * from pg_class indicate error |
Date: | 2012-05-10 15:25:52 |
Message-ID: | CA+U5nMKkY3vs9==Ld_P_vhsYG3AD=XBxwTacMYC1N1V_HUob5g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-bugs |
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