pgPedia

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Top / P

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

Useful articles

System catalog tables
System catalog views
System statistics views
Progress reporting views

Contrib modules
Storage parameters (relopts)

xlog renaming in Pg 10

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

explain.depesz.com/

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 (commit 858ec118).

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)

Details

PostgreSQL 13

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

References

Categories

See also