Re: Ideas to deal with table corruption

On Sat, Jan 6, 2018 at 1:23 PM, Peter Geoghegan <pg(at)bowt(dot)ie> wrote:

> On Sat, Jan 6, 2018 at 2:11 AM, Luis Marin <luismarinaray(at)gmail(dot)com>
> wrote:
> > I am looking for ideas, to help me, check what is happening with a
> possible
> > table corruption, I have some FK that works ok, but some stay in the
> state
> > waiting forever, however selecting the same table works fine.
> >
> > Since, I am a newbie, in PostgreSQL, what should be my firsts steps, in
> > order to have an idea how to fix this problem.
> >
> > I am thinking in watching my postgresql log error file during the
> requests
> > for creating our FK,
> > What do you suggest me
>
> There are CentOS packages for amcheck on 9.4:
>
> https://github.com/petergeoghegan/amcheck#redhatcentossles
>
> I would start there.
>
> --
> Peter Geoghegan
>
>

*>"some stay in the state waiting forever"*

*Don't forget to create indexes on the FK's in the table they reference!*

*Also, it would be nice to know the PostgreSQL version and O/S.*

--
*Melvin Davidson*
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.