Re: BUG #12821: Cannot install xlogdump

Dear Mr Paquier,


We found out, sorry please ignore the previous email,
I then now ran to read out the first 100000 entries



$ cd /usr/lib/postgresql/9.3/bin/
$ sudo ./pg_xlogdump /db/postgres_wal/pg_xlog/00000001000000000000000A -n 100000


to show the content
rmgr: XLOG len (rec/tot): 72/ 104, tx: 0, lsn: 0/0A000028, prev 0/09000090, bkp: 0000, desc: checkpoint: redo
0/A000028;tli 1; prev tli 1; fpw true; xid 0/696; oid 16388; multi 1; offset 0; oldest xid 676 in DB 1; oldest multi 1
inDB 1; oldest running xid 0; shutdown  
rmgr: XLOG len (rec/tot): 0/ 32, tx: 0, lsn: 0/0A000090, prev 0/0A000028, bkp: 0000, desc: xlog switch


is there any statement so that I just run pg_xlogdump with which options so that it will show all the WAL log file from
thebeginning until the end of the WAL log instead of viewing each segment and short info? I suppose that a 16MB WAL log
butonly a piece as above?  

Ha.
----- Original Message -----

From: "Michael Paquier" <michael.paquier@gmail.com>
To: "nlp sr" <nlp.sr@shaw.ca>
Cc: pgsql-bugs@postgresql.org
Sent: Tuesday, March 3, 2015 12:51:02 AM
Subject: Re: [BUGS] BUG #12821: Cannot install xlogdump

On Tue, Mar 3, 2015 at 9:57 AM, <nlp.sr@shaw.ca> wrote:
> We have Postgres 9.3 on Ubuntu 12, however it seems that the xlogdump only
> supports up to Postgres 9.2

Let's be sure that you are not mistaking xlogdump, which is here
(https://github.com/snaga/xlogdump/) and only compatible up to 9.2,
and pg_xlogdump, which is available in-core since 9.3 as a contrib
module:
http://www.postgresql.org/docs/9.3/static/pgxlogdump.html

> On my installation of Postgres 9.3, xlogdump informs mismatched folders.
> But during weekend, we suddenly had huge WAL log file that we have to open
> it to read.
> May you send us a correct link to install a good tool to read our WAL file
> on Postgres 9.3, Ubuntu 12.

If you are using 9.3, you should have a package for contrib modules,
simply deploy it and then use pg_xlogdump. Referring the problem with
"mismatched folders", you will need to give more details because it is
hard to guess what the problem is based on the little information
provided, let us know for example what you tried to do and what is the
error you saw.
Regards,
--
Michael