Download and use pgEdge Platform

• Our container images are designed to run on any modern container platform, including Docker and Kubernetes.

• pgEdge is compatible with Postgres v15, v16, v17 and v18.

Configure your System

If you do not already have a Container runtime, Install Docker

• Use Docker Desktop for macOS, Windows, and Linux Desktop environments.

• Use Docker Engine for Linux server environments.

Install pgEdge Platform

These instructions will create a cluster of 2 containers, each running a pgEdge postgreSQL instance configured with multi-master replication, and a database called "default_db"

Open a terminal and run the following command to download the example Docker Compose file:

Verify database connection

1. Run the example Docker Compose configuration:

2. To open a psql session on the first node, run:

3. Likewise, to open a psql session on the second node, run:

Try out a basic replication

1. Create a table on the first node:

2. Insert a row into our new table on the second node:

3. See that the new row has replicated back to the first node:

Replicate an entire database with the Northwind example dataset

The Northwind example dataset is a PostgreSQL database dump that you can use to try out replication with a more realistic database.

1. To load the Northwind dataset into the first node of your pgEdge database, run:

2. Now, query one of the new tables from the other node:

Connect to example_db from another client

If you have psql, pgAdmin, or another client installed on your host machine, you can use these connection strings to connect to each node:

First node:

Second node:

For example, using psql: