3 ms·
Postgres actually does expose a commit log mechanism since 9.4, expanded with 9.5. http://www.postgresql.org/docs/devel/static/logicaldecoding.html http://www.
by anarazel 11y ago
Postgres actually does expose a commit log mechanism since 9.4, expanded with 9.5.
http://www.postgresql.org/docs/devel/static/logicaldecoding.html http://www.postgresql.org/docs/devel/static/logicaldecoding.... and 9.5's track_commit_timestamp = on.
- buremba 11y agoSorry for the late response. HN just sent me notification mail. The documentation states it as "by default". It's required to change wal settings in config file and write a custom logical decoding output plugin in order to take advantage of that feature. Currently, PaaS provisers such as RDS and Heroku Postgres don't support and it would not be easy to setup it manually. AFAIK, that feature is intended to be to used for backups.