From: | Greg Clough <funcup(at)gmail(dot)com> |
---|---|
To: | PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org> |
Subject: | Re: BUG #13876: pg_xlogdump give an error on timeline switch |
Date: | 2016-01-21 09:20:11 |
Message-ID: | CADjwvTOx8sF26x6YVmWFu6ubBhqeFvHhOAoGuK7AEWZX9psOcA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
>
> (please don't top post on postgres lists)
>
Top posting... sorry, I blame GMail defaults... and mobile phones. :-/
If pg_xlogdump were a tool aimed at normal endusers, maybe. But it's
> clearly not, so ...
>
> What are you using pg_xlogdump for?
>
The issue came about as one of our other DBA's did a role swap
Primary/Standby, but didn't have the recovery_target_timeline = 'latest'
set. He couldn't figure out why the old Primary (now a Standby) wouldn't
follow the new Primary onto the new timeline, and deduced it was a corrupt
WAL due to the output of pg_xlogdump.
I can understand his confusion, as the error is quite alarming with that
big "FATAL:"... but ultimately, yes, it was our own mistake that led us
down this avenue of investigation
The timeline switch will often happen on a different machine, so you
> can't just do that.
>
It's not a huge issue that I doubt we'll ever have again, but if it was an
oversight and easy to fix then I thought it would be worthwhile doing, so
as to stop others having the same problem.
Cheers.
Greg
From | Date | Subject | |
---|---|---|---|
Next Message | andreas.dewes | 2016-01-21 11:03:11 | BUG #13879: include_dir directive not working |
Previous Message | Sandeep Thakkar | 2016-01-21 06:14:49 | Re: BUG #13877: Fails to install |