On Thu, Mar 15, 2018 at 8:16 AM, Andy Halsall <andyh@live.co.uk> wrote:
> Thanks for the advice. I re-indexed and reloaded a pg_dumpall into a spare server - no errors. Will run pg_catcheck
asap.
You can also run amcheck. Get the version targeting earlier Postgres
releases off Github (there are packages for most Linux systems). This
can verify that the heap is consistent with indexes.
--
Peter Geoghegan