Table of Contents
PostgreSQL provides infrastructure to stream the modifications performed via SQL to external consumers. This functionality can be used for a variety of purposes, including replication solutions and auditing.
Changes are sent out in streams identified by logical replication slots.
The format in which those changes are streamed is determined
by the output plugin used. An example plugin is provided in the
PostgreSQL distribution. Additional plugins can be written to
extend the choice of available formats without modifying any core
code. Every output plugin has access to each individual new row
INSERT and the new row
version created by
Availability of old row versions for
depends on the configured replica identity (see
Changes can be consumed either using the streaming replication protocol (see Section 53.4 and Section 49.3), or by calling functions via SQL (see Section 49.4). It is also possible to write additional methods of consuming the output of a replication slot without modifying core code (see Section 49.7).
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.