Re: Question on corruption (PostgreSQL 9.6.1)

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: Andy Halsall <andyh(at)live(dot)co(dot)uk>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Question on corruption (PostgreSQL 9.6.1)
Date: 2018-03-16 18:24:23
Message-ID: CAH2-WzkBaQby9QtmWAqczWGtEaOTYKiGuS_+VpDprYJ==e7qDQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Mar 15, 2018 at 8:16 AM, Andy Halsall <andyh(at)live(dot)co(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Charlin Barak 2018-03-16 18:36:31 Re: ora2pg and invalid command \N
Previous Message Pavel Stehule 2018-03-16 18:06:38 Re: ora2pg and invalid command \N