Re: Ideas to deal with table corruption

On 01/06/2018 02:11 AM, Luis Marin wrote:
>
> 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.

From further comments below I think you are talking about creating a FK
on a table, is that correct?

If not, what are you trying to do?

The table schema and code showing your process would be helpful.

And yes tailing the Postgres log file during the above could be helpful.

>
> 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

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com