2009/8/21 Radoslaw Zielinski <ra...@pld-linux.org>:
> Greg Stark <gsst...@mit.edu> [2009-08-21 18:03]:
>> On Fri, Aug 21, 2009 at 4:04 PM, Radoslaw Zielinski<ra...@pld-linux.org>
>> wrote:
>>> This particular row currently has last_modified="2009-08-11", but table_log
>>> says it has been updated on "2009-08-12" -- so, data loss.
>
>> These are all very low transaction ids. you say it was a week of
>> production before this happened?
>
> Upgraded around:
> $ rpm -q postgresql --qf '%{INSTALLTIME}' | xargs perl -le 'print~~localtime
> shift'
> Fri Aug 7 10:06:44 2009
Is this, perchance, new hardware? Did you test the memory in it?
Do you have other records that have "disappeared"?
--
greg
http://mit.edu/~gsstark/resume.pdf
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
