README.md

Our Distributed Multi-master Postgres runs nicely (on most all flavors of Linux) in vm's, containers, bare metal, or a localhost sandbox.

You can join our Discord Server or learn more about our sponsor. Also check out our Docker or K8's Helm examples.

Getting started

Start by installling CLI on a single node (per below) and then looking next at quick tutorial for setting up a test cluster

Node Pre-Reqs

• Use a non-root user from the command line

• Tested with Python 3.9 thru 3.12

  • Python 3.9 on EL8, EL9, SLE-15, & Amazon Linux 2023
  • Python 3.10 on Ubuntu 22.04
  • Python 3.11 on Debian 12
  • Python 3.12 on Ubuntu 24.04

• optional: config password-less sudo if you want to autostart components with systemctl

• optional config password-less ssh to localhost for using localhost cluster commands

python3 -c "$(curl -fsSL https://pgedge-upstream.s3.amazonaws.com/REPO/install.py)"

Try a cluster tutorial using localhost or vm's

Learn more about our family of supported components

Get a feel for our powerful CLI commands

   spock - Custom configure world's best logical & multi-master distributed Postgres

   localhost - Create a localhost test cluster

   cluster - Define & control a cluster of nodes

   ace - The Anti-Chaos Engine efficiently assures your distributed data is in sync

   db - Configure and control distributed PostgreSQL DB's

   um - Update Manager commands

   service - Service control commands

CLI Examples

Sandbox with latest Postgres 16, Spock & Snowflake installed into default postgres db

./pgedge install pg16 --start : install spock : install snowflake

Create database db1 owned by denis & setting up Spock & Snowflake into pg16

./pgedge setup -U denis -P secret -d db1 --pg_ver 16

Create a cluster cl1 on localhost with two nodes, then install northwind sample app on cluster

./pgedge localhost cluster-create cl1 2 : cluster app-install cl1 northwind