| From: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> |
|---|---|
| To: | Alex Ignatov <a(dot)ignatov(at)postgrespro(dot)ru> |
| Cc: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Why we don't have checksums on clog files |
| Date: | 2016-06-07 14:41:43 |
| Message-ID: | CAA4eK1L=XS3k7X9pfYKOZ6KGu2PbzGiX+1NF-dFkC35FJMCtWQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Mon, Jun 6, 2016 at 8:43 PM, Alex Ignatov <a(dot)ignatov(at)postgrespro(dot)ru>
wrote:
> Hello!
>
> Why we don't have checksums on clog files.
>
> We have checksum on pg_control, optional checksumming on data files, some
> form of checksumming on wal's. But why we don't have any checksumming on
> clogs. Corruptions on clogs lead to transaction visisbility problems and
> database consistency violation.
>
> Can anybody explain this situation with clogs?
>
>
I think it will be better if users can have an option to checksum clog
pages. However, I think that will need a change in page (CLOG-page) format
which might not be a trivial work to accomplish.
With Regards,
Amit Kapila.
EnterpriseDB: http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexander Korotkov | 2016-06-07 14:54:12 | Re: Why we don't have checksums on clog files |
| Previous Message | Tom Lane | 2016-06-07 14:30:18 | Re: installcheck failing on psql_crosstab |