Download and use pgEdge Platform

• Our optimized and secure static binaries are tested on popular amd64 & arm64 Linux distributions, including RHEL/CentOS/Rocky 9 and Ubuntu 22.04. with Python 3.9+

• We are compatible with Postgres v15, v16, v17 and v18

• pgEdge will run in sandboxes, virtual machines, or containers

• For containers, we recommend using our Container Install Instructions

Configure your System

Ensure your system is configured according to prerequisites:

• Set SELinux to permissive or disabled mode on each host, followed by a system reboot.

• Configure passwordless sudo access for a non-root OS user.

• Configure passwordless ssh access for the same non-root OS user.

Install pgEdge Platform

These instructions will install the pgEdge platform and create a cluster of 2 running PostgreSQL instances configured with multi-master replication, and a database called "defaultdb"

The two instances will be running on ports 6432 and 6433

1. Open a terminal to your $HOME directory (as a non-root user), and run the following command to download and install pgEdge:

2. Create a 2-node cluster by running:

Note: If you’re remotely connected to a VM, you may be prompted with Are you sure you want to continue connecting? — answer yes to proceed.

Verify database connection

1. Set up your environment to use psql: (Optional, and only needed if you don't already have psql configured)

2. Verify you can connect to Node 1:

3. Verify you can connect to Node 2:

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: