Ideas to deal with table corruption

From: Luis Marin <luismarinaray(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Ideas to deal with table corruption
Date: 2018-01-06 10:11:57
Message-ID: CAEp6HQXseuvaU_UGOju3rMduhHB+QTYcZa5oda+_82eQ73DVtw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Dear community,

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

Centos 7.2
Postgresql 9.4

Thanks

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Adrian Klaver 2018-01-06 17:39:59 Re: Ideas to deal with table corruption
Previous Message Azimuddin Mohammed 2018-01-06 02:30:52 Re: Postgres HA

Browse pgsql-general by date

  From Date Subject
Next Message Marco Nenciarini 2018-01-06 14:40:58 Re: [PATCH] Logical decoding of TRUNCATE
Previous Message Travis Allison 2018-01-06 05:36:49 Re: What generates pg_config.h?