Skip to content

stephane-klein/postgresql-logical-replication-playground

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

7 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

PostgreSQL 12 logical replication playground

PostgreSQL 12 logical replication playground, based on this documentation: Logical Replication in PostgreSQL Explained

$ docker-compose up -d postgres1
$ ./scripts/wait-service.sh postgres1 5432
$ ./scripts/pg1/load-configuration.sh
$ ./scripts/pg1/load-seed.sh
$ ./scripts/pg1/insert-fixtures.sh
$ docker-compose up -d postgres2
$ ./scripts/wait-service.sh postgres2 5432
$ ./scripts/pg2/create-extensions.sh
$ ./scripts/pg2/copy-from-pg1.sh
$ ./scripts/pg2/create-subscriptions.sh
$ ./scripts/pg2/query.sh
count
-------
    10
$ ./scripts/pg1/insert-fixtures.sh
$ ./scripts/pg2/query.sh
count
-------
    20

About

PostgreSQL 12 logical replication playground

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published