Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

PostgreSQL Replication slot


You can create a replication slot like this:
postgres=# SELECT * FROM pg_create_physical_replication_slot('node_a_slot');
  slot_name  | xlog_position
 node_a_slot |

postgres=# SELECT * FROM pg_replication_slots;
  slot_name  | slot_type | datoid | database | active | xmin | restart_lsn | confirmed_flush_lsn
 node_a_slot | physical  |        |          | f      |      |             |
(1 row)
To configure the standby to use this slot, primary_slot_name should be configured in the standby's recovery.conf. Here is a simple example:
standby_mode = 'on'
primary_conninfo = 'host= port=5432 user=foo password=foopass'
primary_slot_name = 'node_a_slot'


Popular posts from this blog

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

PostgreSQL pgBadger

7 Steps to configure BDR replication in postgresql

Postgres Database Patch