Create PostgreSQL Cluster Configuration

CSD for streaming Mode

requirement

1. Support Postgresql version

   1. v10 - v14

   2. Both servers should be running same version

2. Network connectivity

   1. The servers must be on the same network and have proper network connectivity

   2. Primary server should have proper pg_hba.conf setting

1. Trigger CSD in streaming mode

2. Create Replication Slot on Primary

   1. SELECT * FROM pg_create_physical_replication_slot(SLOT_NAME, false, false) WHERE NOT EXISTS (SELECT * FROM pg_replication_slots WHERE slot_name = SLOT_NAME)

3. On Primary MP find and Tar the postgresql config files, Including

   1. postgres.conf

   2. pg_ident.conf

   3. pg_hba.conf

4. On Standby MP receive tar ball of postgresql config files from Primary server

5. Data directory setup: Using pg_basebackup to initialize streaming backup from Standby to Primary to retrieve all files in data directory from Primary with the Replication Slot created on step 2

   1. /opt/rh/rh-postgresql13/root/usr/bin/pg_basebackup -D /var/lib/pgsql/data/13/main -F plain -X stream -S dbvisit_2 -R --progress --verbose --checkpoint=fast -d postgres://postgres@postgresqlcentos1:5432

6. Config directory setup: Extract files from tar ball recieved on step 4 and put them into the target config directory

7. After setting up data director and config directory, restart standby server

8. Applying the latest changes on configuration coming CSD and persisting configuration data on Control Center

CSD for archive Mode