From PostgreSQL wiki
Jump to navigationJump to search

Custom WAL Resource Manager (rmgr)

Extensions can register their own custom WAL resource managers to support custom redo, physical replication, and logical replication/decoding.

Each resource manager needs to register using a unique ID (across all extensions) to prevent problems with crash recovery and replication. The IDs are limited, however, and only IDs between 128 and 255 (inclusive) are available for custom resource managers.

This page lists the current extensions that require a custom resource manager, and the IDs which are reserved for them. If your extension requires a new custom resource manager, start out by using RM_EXPERIMENTAL_ID (128). When the project is close to release or being used in production, choose an unused resource manager ID and add to this list to reserve it.

List of Custom Rmgrs

RmgrId Extension Description
128 N/A Used for extensions still in development
129 OrioleDB OrioleDB – building a modern cloud-native storage engine (... and solving some PostgreSQL wicked problems) 🇺🇦
130 EnterpriseDB Bluefin – Compressed IoT storage
131 EnterpriseDB Bluefin2 – Compressed IoT storage
241 Columnar Columnar compression extension