Postgres Pro
Downloads
Home   >   mailing lists

"index contains unexpected zero page" problem - Mailing list pgsql-general

From Yi Sun
Subject "index contains unexpected zero page" problem
Date
Msg-id CABWY_HBQeWRXK5rMPQoCrHi70nRUpKVcq5f+nedFO-dx8f0NQA@mail.gmail.com
Whole thread Raw
List pgsql-general
Tree view
Hi guys,

We face "index contains unexpected zero page" problem in prd postgresql 11 environment

This url shows that need to backup database firstly, is it necessary?

If "create index concurrently" create a new index and drop the old broken index is a solution to avoid table lock please? Thanks

Best Regards
Dennis

pgsql-general by date:

Previous
From: Siddhartha2485
Date:
Subject: Re: ERROR : invalid transaction termination : PostgreSQL v12
Next
From: Niels Jespersen
Date:
Subject: where clauses including timstamptz and intervals