>
> First things first: Before you do anything else, shut down
> PostgreSQL and make a copy of the data directory tree.
>
> http://wiki.postgresql.org/wiki/Corruption
>
Did it.
> Second, please post information about your environment. What
> version of PostgreSQL is this? What is your OS? What hardware is
> it running on?
>
Version 9.0.4 on debian squeeze 6.0 running in KVM with virtio (kernel 2.6.32)
I think we have a hard drive issue.
> Now, please copy from the log at the time of the crash and post all
> messages, plus any possibly relevant messages in the clients and the
> OS logs. Is there a core file from the crash? Can you get a
> backtrace from it?
>
I rm the log file has it was taking too much space because of the 1000
warning per seconds.
I feel dumb right now. Sorry.
>
> It's best to keep notes of exactly what was done. What was the
> process description of what you killed? Which signal did you use?
> Keep notes as you go.
>
kill -9 of the writer process
>
> Copy/paste it?
>
Sorry lost it but it was xlog flush request 0/xxxx is not satisfied
--- flushed only to xxxx
>
> How big is the table? What kind of column(s) in the index?
>
primary key index on int32, table have 1.2M lines
--
Yann