primary_slot_name
A configuration parameter determining the name of a replication slot to be used by a standby
primary_slot_name
is a configuration parameter determining the name of a replication slot to be used by a streaming replication standby.
primary_slot_name
was added in PostgreSQL 9.4.
Default value
The default value for primary_slot_name
is: ''
(empty string).;
Definition by PostgreSQL version
postgres=# SELECT * FROM pg_settings WHERE name='primary_slot_name'; -[ RECORD 1 ]---+-------------------------------------------------------------------- name | primary_slot_name setting | standby_slot_2 unit | category | Replication / Standby Servers short_desc | Sets the name of the replication slot to use on the sending server. extra_desc | context | sighup vartype | string source | configuration file min_val | max_val | enumvals | boot_val | reset_val | standby_slot_2 sourcefile | sourceline | 5 pending_restart | f
Change history
- PostgreSQL 13
- changes to
primary_slot_name
can now be applied with a simple configuration reload usingpg_reload_conf()
,pg_ctl reload
orSIGHUP
(commit 1e614803)
- changes to
- PostgreSQL 12
- change from a recovery.conf parameter to a normal GUC parameter (commit 2dedf4d9)
- PostgreSQL 9.4
References
- PostgreSQL documentation: primary_slot_name