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.
It makes no difference if you replicate within an instance or between two instances—it works exactly the same way.
Creating those 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, which should be replicated from database
db1 to database
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" ...