PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

Assuming we have two nodes in pgha1 and pgha2 and a BDR-enabled database named myapp, follow these steps to manage and use sequences:

1. Execute the following statement on any BDR node before using any DDL that contains BIGSERIAL or SEQUENCE:

SET bdr.default_sequence_kind = 'timeshard'; 

2. Create a SEQUENCE and check the results as follows:

CREATE SEQUENCE myseq; 
SELECT nextval('myseq'); 

3. Create a BIGSERIAL table and insert a test record as follows:

DROP TABLE IF EXISTS event_log; 
CREATE TABLE event_log ( 
  event_id  BIGSERIAL PRIMARY KEY, 
  event     VARCHAR(100) NOT NULL, 
  event_dt  TIMESTAMPTZ NOT NULL DEFAULT now() 
); 
 
INSERT INTO event_log (event) VALUES ('Testing'); 
SELECT * FROM event_log; 

4. Use the following query to check the ...