Wiki / Configuration Parameters

Controls firing of replication-related triggers and rules for the current session. Possible values are origin (the default), replica and local. Setting this parameter results in discarding any previously cached query plans. Only superusers and users with the appropriate SET privilege can change this setting. The intended use of this setting is that logical replication systems set it to replica when they are applying replicated changes. The effect of that will be that triggers and rules (that have not been altered from their default configuration) will not fire on the replica. See the ALTER TABLE clauses ENABLE TRIGGER and ENABLE RULE for more information. PostgreSQL treats the settings origin and local the same internally. Third-party replication systems may use these two values for their internal purposes, for example using local to designate a session whose changes should not be replicated. Since foreign keys are implemented as triggers, setting this parameter to replica also disables all foreign key checks, which can leave data in an inconsistent state if improperly used.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

boot val

origin

category

Client Connection Defaults / Statement Behavior

context

superuser

documented

true

enumvals

origin, replica, local

extra desc

Unknown

lang

en

max val

Unknown

metadata version

18

min val

Unknown

name

session_replication_role

short desc

Sets the session's behavior for triggers and rewrite rules.

source

pg-settings-source-snapshot

unit

Unknown

vartype

enum