bdr15k,luss

bdr15k's Introduction

bdr15k requires PostgreSQL 15

Sample usage:
```
#backup database before cluster drop if exists:
/usr/lib/postgresql/15/bin/bdr_dump -p 5434 -N bdr radius > backup.sql

pg_dropcluster 15 node1 --stop
pg_dropcluster 15 node2 --stop

rm -r /etc/postgresql/15/node1/conf.d/
rm -r /etc/postgresql/15/node2/conf.d/

pg_createcluster 15 node1
pg_createcluster 15 node2

pg_ctlcluster 15 node1 start
pg_ctlcluster 15 node2 start

psql -p 5434 -c 'create database radius'
psql -p 5435 -c 'create database radius'

cat <<EOF | tee /etc/postgresql/15/node1/conf.d/bdr.conf /etc/postgresql/15/node2/conf.d/bdr.conf
shared_preload_libraries = 'bdr'
bdr.trace_replay = on
wal_level = 'logical'
track_commit_timestamp = on
max_replication_slots = 20
max_wal_senders = 10
EOF

pg_ctlcluster 15 node1 restart
pg_ctlcluster 15 node2 restart

psql -p 5434 radius -c 'create extension bdr cascade' -c "SELECT bdr.bdr_group_create(local_node_name := 'node1', node_external_dsn := 'dbname=radius port=5434')" -c 'select bdr.bdr_node_join_wait_for_ready()'
psql -p 5435 radius -c 'create extension bdr cascade' -c "SELECT bdr.bdr_group_join(local_node_name := 'node2', node_external_dsn := 'dbname=radius port=5435', join_using_dsn := 'dbname=radius port=5434')" -c 'select bdr.bdr_node_join_wait_for_ready()'

#restore if any backup
psql -p 5434 radius -1 -f backup.sql

psql -p 5434 radius -c "CREATE TABLE IF NOT EXISTS test (id bigserial, name text)" -c "ALTER TABLE test ALTER COLUMN id SET DEFAULT bdr.global_seq_nextval('test_id_seq'::regclass)"

psql -p 5434 radius -c "insert into test(name) values('foo')"
psql -p 5435 radius -c "insert into test(name) values('bar')"

psql -p 5434 radius -c 'select count(*) from test'
psql -p 5435 radius -c 'select count(*) from test'
```

Recommend Projects