PostgreSQL Replication - Second Edition

Replicating your first database

After this little introduction, we can move forward and replicate our first database. To do so, we can create two databases in a database instance. We want to simply replicate between these two databases.

Tip

It makes no difference if you replicate within an instance or between two instances—it works exactly the same way.

Creating the two databases should be an easy task once your instance is up and running:

hs@hs-VirtualBox:~$ createdb db1
hs@hs-VirtualBox:~$ createdb db2

Now we can create a table that should be replicated from database db1 to database db2:

db1=# CREATE TABLE t_test (id serial, name text,
PRIMARY KEY (id));
NOTICE: CREATE TABLE will create implicit sequence "t_test_id_seq" for serial column "t_test.id" ...