On 2016-04-07 12:26:28 +0900, Fujii Masao wrote: > In my example, the WAL record of INSERT that I executed last should be in > 000000010000000000000005. But pg_xlogdump could not display that. > The output of pg_xlogdump was: > > $ pg_xlogdump data/pg_xlog/000000010000000000000005 > pg_xlogdump: FATAL: could not find a valid record after 0/5000000 > > ISTM that if a WAL file starts with the latter half of LOGICAL MESSAGE > WAL data, pg_xlogdump treats it as invalid and gives up dumping the > remaining WAL data in the file.
That'd obviously be something to investigate. IIRC there's a thread nearby about something like this. But just to confirm, if you use -s over multiple records it works? Greetings, Andres Freund -- Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-committers