session_replication_role
A server parameter controlling replication-related triggers and rules
session_replication_role
is a configuration parameter controlling the firing of replication-related triggers and rules.
session_replication_role
was added in PostgreSQL 8.3.
Usage
Possible values for session_replication_role
are:
origin
local
replica
Currently origin
and local
are equivalent.
Setting session_replication_role
to replica
means that triggers (including foreign keys) and rules will not be applied. This is mainly intended for use in by logical replication systems.
Default value
The default value for session_replication_role
is: origin
.
Change history
- PostgreSQL 8.3
- added (commit 0fe16500)
References
- PostgreSQL documentation: session_replication_role
Categories
See also
logical replication, ALTER TABLE