On 10/22/15 11:25 AM, bricklen wrote:
I would have liked to have had the opportunity to answer those questions myself but alas, in the heat of the moment some of the data useful for forensics was lost.
You could always roll WAL forward from the previous base backup and see what happens.
FWIW, most times that I've experienced corruption it's percolated through the WAL stream as well, presumably due to full_page_writes. It's why I like making londiste part of the DR configuration for really high-value data. Of course, if you're having corruption problems then it's also very possible that your user data is getting crapped on too, and logical replication won't help you terribly much there. I investigated adding user-space row-level checksums but never actually rolled that out. Of course now you'd just use page level checksums.
-- Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX Experts in Analytics, Data Architecture and PostgreSQL Data in Trouble? Get it in Treble! http://BlueTreble.com -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
