On 2016-06-07 17:53:46 +0000, Bo Ørsted Andresen wrote:
> > On 2016-06-07 19:41, Andres Freund wrote:
> > > Not sure what else I can do short of recompiling postgresql mysql.
> >
> > Any chance the running version of postgres is out of date with the installed
> > binaries / debug symbols?
>
> You mean that I upgraded without restarting postgres before the segfault?
Yes, that's what I was wondering. But alas, that's aparently not the
reason.
This is going to be a bit more complicated, sorry :(
Could you try to reproduce the problem, and do 'p/x ReadRecPtr'? That
should give you something like 0x5434343496. If you rewrite this as
first-four-bytes/last-four-bytes e.g. 54/34343496 you get the LSN. With
that, could you try
pg_xlogdump -p /path/to/data/directory -s 54/34343496 -n 100
and send the output?
Regards,
Andres