On Mon, May 30, 2016 at 10:57 AM, Alex Ignatov <a.ignatov@xxxxxxxxxxxxxx> wrote: > Following this bug reports from redhat > https://bugzilla.redhat.com/show_bug.cgi?id=845233 > > it rising some dangerous issue: > > If on any reasons you data file is zeroed after some power loss(it is the > most known issue on XFS in the past) when you do > select count(*) from you_table you got zero if you table was in one > 1GB(default) file or some other numbers !=count (*) from you_table before > power loss > No errors, nothing suspicious in logs. No any checksum errors. Nothing. > > Silent data loss is its pure form. > > And thanks to all gods that you notice it before backup recycling which > contains good data. > Keep in mind it while checking you "backups" in any forms (pg_dump or the > more dangerous and short-spoken PITR file backup) > > You data is always in danger with "zeroed data file is normal file" > paradigm. That bug shows as having been fixed in 2012. Are there any modern, supported distros that would still have it? It sounds really bad btw. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
