Search Postgresql Archives

Re: Ideas to deal with table corruption

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.klaver@xxxxxxxxxxx




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux