| From: | legrand legrand <legrand_legrand(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Logging the feature of SQL-level read/write commits |
| Date: | 2019-05-05 10:14:36 |
| Message-ID: | 1557051276747-0.post@n3.nabble.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Hello,
may be you can find more informations regarding WAL concepts in
Write Ahead Logging — WAL
http://www.interdb.jp/pg/pgsql09.html
It seems very complicated to change WAL format ...
Maybe there are other solutions to answer your need,
I found many interesting solutions in postgres archives searching
with words "flashback", "timetravel", "tablelog", ...
My prefered is "AS OF queries"
https://www.postgresql.org/message-id/flat/78aadf6b-86d4-21b9-9c2a-51f1efb8a499%40postgrespro.ru
and more specificaly syntax
VERSIONS BETWEEN SYSTEM TIME ... AND ...
that would permit to get history of modifications for some rows
and help fixing current data
Regards
PAscal
Regards
PAscal
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-hackers-f1928748.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2019-05-05 12:09:02 | Re: Logging the feature of SQL-level read/write commits |
| Previous Message | Amit Kapila | 2019-05-05 04:58:21 | Re: POC: Cleaning up orphaned files using undo logs |