How to use pg_waldump? - Mailing list pgsql-general

From André Hänsel
Subject How to use pg_waldump?
Date
Msg-id 0c1c01d61fa5$f4f23ff0$ded6bfd0$@webkr.de
Whole thread Raw
Responses Re: How to use pg_waldump?  (Paul Förster <paul.foerster@gmail.com>)
List pgsql-general
I’m using pgBackRest for incremental backups which, as far as I understand,
use the WAL. These backups are relatively large, so I wanted to take a look
at my WAL. I understand pg_waldump is the tool for this.

However, I struggle with its usage.

The --help output suggests all command line parameters are optional, but
running it like that yields "pg_waldump: no arguments specified". So I tried
"pg_waldump -z" which yields "pg_waldump: FATAL:  could not find any WAL
file". Ok, so apparently it doesn't know the location of the WAL files. I
then tried "pg_waldump -p /var/lib/postgresql/11/main/pg_wal".

Now I get "pg_waldump: no start WAL location given". And this is where I'm
stuck. I don't know any WAL location. I don't even know how far back my WAL
goes, that's one thing I want to find out, among other things.

On https://www.postgresql.org/docs/11/pgwaldump.html it says about
"--start":
> WAL location at which to start reading. The default is to start reading
the first valid log record found in the earliest file found.

If that's the default, why does it ask me for a WAL location?

What do I need to do?




pgsql-general by date:

Previous
From: legrand legrand
Date:
Subject: Re: pg_stat_statements : how to catch non successfully finishedstatements ?
Next
From: Paul Förster
Date:
Subject: Re: How to use pg_waldump?