Re: BUG #12821: Cannot install xlogdump

Dear Mr Paquier, 


May I ask this question 


I installed postgres-conrib by 



sudo apt-get install postgresql-contrib-9.3 
sudo service postgresql stop 
sudo service postgresql start 


Now I found my pg_xlogdump at 

$ sudo find / -name pg_xlog* 
/usr/lib/postgresql/9.3/bin/pg_xlogdump 
/usr/share/postgresql/9.3/man/man1/pg_xlogdump.1.gz 
/usr/share/man/man1/pg_xlogdump.1.gz 
/db/postgres_wal/pg_xlog 
/db/postgres_data/main/pg_xlog 
/etc/alternatives/pg_xlogdump.1.gz 


Hence I ran 
$ cd /usr/lib/postgresql/9.3/bin/ 
$ sudo pg_xlogdump /db/postgres_wal/pg_xlog/00000001000000000000000B 
But error 


sudo: pg_xlogdump: command not found 


I tried again without sudo 


$ pg_xlogdump /db/postgres_wal/pg_xlog/00000001000000000000000B 

error 
-bash: pg_xlogdump: command not found 


May you support, 
Ha. 
----- Original Message -----

From: "Michael Paquier"  
To: "nlp sr"  
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,  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