Book Image

PostgreSQL Replication, Second Edition

Book Image

PostgreSQL Replication, Second Edition

Overview of this book

Table of Contents (22 chapters)
PostgreSQL Replication Second Edition
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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"
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "t_test_pkey" for table "t_test"
CREATE TABLE

Create this table in both the databases in an identical manner, because the table structure won't be replicated automatically.

Tip

Replicating...