Willy Ristanto's Blog: PostgreSQL : Load Balancing and Replication with PgPool II-92 (Part 3)

Previous : Part 2 http://willyristanto.blogspot.com/2014/10/clustering-postgresql-with-pgpool-ii-92_15.html

12. Testing Replication

Now, we can test replication via application. First, make sure connection to pgpool is OK

Execute query:
CREATE TABLE "public"."test_1" (
    "id"     int NULL primary key,
    "name"    varchar(25) NULL
    )

INSERT INTO "public"."test_1"("id", "name")
VALUES(1, 'one')
;
INSERT INTO "public"."test_1"("id", "name")
VALUES(2, 'two')
;

when we check both on server postgres1 and server postgres2