Chapter 49. Archive Modules
Table of Contents
PostgreSQL provides infrastructure to create custom modules for continuous archiving (seeSection 25.3). While archiving via a shell command (i.e.,archive_command) is much simpler, a custom archive module will often be considerably more robust and performant.
When a customarchive_library is configured, PostgreSQL will submit completed WAL files to the module, and the server will avoid recycling or removing these WAL files until the module indicates that the files were successfully archived. It is ultimately up to the module to decide what to do with each WAL file, but many recommendations are listed atSection 25.3.1.
Archiving modules must at least consist of an initialization function (seeSection 49.1) and the required callbacks (seeSection 49.2). However, archive modules are also permitted to do much more (e.g., declare GUCs and register background workers).
Thecontrib/basic_archive module contains a working example, which demonstrates some useful techniques.