Re: [GENERAL] Index corruption & broken clog

2017-10-13 Thread Benoit Lobréau
I seem that a failed vmotion occured in the same time frame.

Re: [GENERAL] Index corruption & broken clog

2017-10-13 Thread Benoit Lobréau
Thanks for the help. > Shut down the corrupted database and make a physical backup of it. > I did it before trying anything. > Check the disks and memory on the machine where the problem occurred. > We are using virtual machines (VMWare). I will ask then to investigate anyway. > You can t

Re: [GENERAL] Index corruption & broken clog

2017-10-13 Thread Laurenz Albe
Benoit Lobréau wrote: > One of my PostgreSQL server crashed badly yesterday. A process was killed > (see dmesg below) and postgres was stuck with theses process: > > postgres  2083     1  0 Oct08 ?        00:19:02 > /usr/lib/postgresql/9.5/bin/postgres -D /home/postgres/data/i090/systeme > p

[GENERAL] Index corruption & broken clog

2017-10-12 Thread Benoit Lobréau
Hi, One of my PostgreSQL server crashed badly yesterday. A process was killed (see dmesg below) and postgres was stuck with theses process: postgres 2083 1 0 Oct08 ?00:19:02 /usr/lib/postgresql/9.5/bin/postgres -D /home/postgres/data/i090/systeme postgres 2221 2083 0 Oct08 ?