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" <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