This problem happened recently to couple of people on various Pg support channels, so I figured I can write a bit more about it, so that in future I have a place where I can refer people to 🙂
Tag: archiving
Waiting for PostgreSQL 15 – Allow archiving via loadable modules.
On 3rd of February 2022, Robert Haas committed patch:
Allow archiving via loadable modules. Running a shell command for each file to be archived has a lot of overhead and may not offer as much error checking as you want, or the exact semantics that you want. So, offer the option to call a loadable module for each file to be archived, rather than running a shell command. Also, add a 'basic_archive' contrib module as an example implementation that archives to a local directory. Nathan Bossart, with a little bit of kibitzing by me. Discussion: http://postgr.es/m/20220202224433.GA1036711@nathanxps13
Continue reading Waiting for PostgreSQL 15 – Allow archiving via loadable modules.
Waiting for 9.4 – Add pg_stat_archiver statistics view.
On 28th of January, Fujii Masao committed patch:
Add pg_stat_archiver statistics view. This view shows the statistics about the WAL archiver process's activity. Gabriele Bartolini, reviewed by Michael Paquier, refactored a bit by me.
Continue reading Waiting for 9.4 – Add pg_stat_archiver statistics view.