Question on corruption (PostgreSQL 9.6.1)

2018-03-13 Thread Andy Halsall
Following a number of kernel crashes due to memory corruption, we experienced "ERROR: invalid memory alloc request size 8589934587" from pg_dump. We assume because of corruption to a PostgreSQL page due to the same memory problems causing the crashes. Fortunately this was low impact - we could r

Re: Question on corruption (PostgreSQL 9.6.1)

2018-03-16 Thread Andy Halsall
Thanks for the advice. I re-indexed and reloaded a pg_dumpall into a spare server - no errors. Will run pg_catcheck asap. regards, Andy Andy Halsall writes: >  db=# select * from x where col_a = 4675635; >  col_a   | col_b   | col_c   | col_d |