• Browse categories
• PostgreSQL releases
  • PostgreSQL 15 (dev)
  • PostgreSQL 14 (beta3)
  • PostgreSQL 13 (latest)
  • PostgreSQL 12
  • PostgreSQL 11
  • PostgreSQL 10
  • PostgreSQL 9.6
  • PostgreSQL 9.5 (EOL)

Version charts

Useful overviews

Useful links

primary_slot_name

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 using pg_reload_conf(), pg_ctl reload or SIGHUP (commit 1e614803)
• PostgreSQL 12
  • change from a recovery.conf parameter to a normal GUC parameter (commit 2dedf4d9)
• PostgreSQL 9.4
  • added (commit 858ec118 as primary_slotname, renamed to primary_slot_name in commit f0c10856)

References

Categories

See also