Postgres recovered from data folder , after that some queries shows error
select * from table2 order by app_id ; - its work ( 50000000 data)
select * from table2 order by app_id desc ; - its work
Here app_id contains binary index
select * from table2 order by id ; - its work ( 50000000 data)
select * from table2 order by id desc ; - shows following error
manoj[local] postgres ERROR: index "tbl2_id_pkey" contains unexpected zero
page at block 311121
manoj [local] postgres HINT: Please REINDEX it.
index "tbl2_id_pkey" is primary key
Reindex not pratical this table (250 GB data)
How i can solve this ?
Regards
Manoj K P
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Primary-key-Index-Error-tp4931714p4931714.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.