| From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
|---|---|
| To: | André Hänsel <andre(at)webkr(dot)de> |
| Cc: | 'Paul Förster' <paul(dot)foerster(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: How to use pg_waldump? |
| Date: | 2020-05-01 23:27:00 |
| Message-ID: | 20200501232700.GA31289@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 2020-May-01, André Hänsel wrote:
> Paul Förster wrote:
>
> > maybe try with another WAL file or files?
> >
> > Works for me...
>
> Ok, I tried it with all the files in the pg_wal directory and it
> worked with one: the first one (lexicographically/hex).
The other files have not yet been written, so pg_waldump cannot read
them. If you can find out what was the name of the file that it had
before the recycling, you can rename (a copy of) the file to that, and
then pg_waldump will be able to read it. (You can try brute-forcing the
search for the correct file name).
If you have an archive_command-generated archive of WALs, or
pg_receivewal, those files should all be readable by pg_waldump.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | TalGloz | 2020-05-02 07:30:53 | Re: Checking for Presence of Required Libraries Fails during PostgreSQL Upgrade |
| Previous Message | Adrian Klaver | 2020-05-01 22:45:32 | Re: Checking for Presence of Required Libraries Fails during PostgreSQL Upgrade |