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

PostgreSQL pgBadger

PostgreSQL Pgbadger Installation On Linux

How to configure Replication Manager (repmgr) ?

What's is the difference between streaming replication Vs hot standby vs warm standby ?

PostgreSQL Sequence