Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have setup streaming replication on Postgres 9.1.6 running on a debian server and it's going on fine.

When I try to run a query on the replica DB I get the error below:

ERROR:  index "tbl_cust_id_idx" contains unexpected zero page at block 0
HINT:  Please REINDEX it.

What might be causing this error?

The question is also posted in http://stackoverflow.com/questions/17865135/postgres-9-1-6-error-index-contains-unexpected-zero-page-at-block-0

share|improve this question
    
Can you run any other queries: SELECT version() or SELECT now()? –  Richard Huxton Jul 25 '13 at 18:55
1  
Do you get this error when you connect to the database? Can you connect at all? If yes, can you successfully issue queries? Otherwise, this doesn't look very good. What are your fsync-related settings on the replica? What do we know about the storage system there? –  dezso Jul 25 '13 at 20:33
    
Try reindex the index "tbl_cust_id_idx" . May be it will do. –  francs Jul 26 '13 at 2:51
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.