PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

Assuming that we have two nodes in pgha1 and pgha2 and a BDR-enabled database named myapp, follow these steps to test the DDL replication:

1. Execute the following SQL on pgha1:

CREATE TABLE event_log (
  event_id  BIGSERIAL PRIMARY KEY,
  event     VARCHAR(100) NOT NULL,
  event_dt  TIMESTAMPTZ NOT NULL DEFAULT now()
); 

2. Execute the following SQL on pgha2:

CREATE INDEX idx_event_log_event_dt
    ON event_log (event_dt);

3. Examine the table on pgha1 by using this command in psql (for example):

\d event_log