Skip to content

pgEdge/pgedge

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

# pgEdge Distributed Postgres

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