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.


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


GUC configuration item, Replication

See also

logical replication, ALTER TABLE