Show HN: PgDog – Shard Postgres without extensions
Published on: 2025-06-22 03:55:49
PgDog is a transaction pooler and logical replication manager that can shard PostgreSQL. Written in Rust, PgDog is fast, secure and can manage hundreds of databases and hundreds of thousands of connections.
Documentation
📘 PgDog documentation can be found here. Any questions? Join our Discord.
Quick start
Kubernetes
Helm chart is here. To install it, run:
git clone https://github.com/pgdogdev/helm && \ cd helm && \ helm install -f values.yaml pgdog ./
Docker
You can try PgDog quickly using Docker. Install Docker Compose and run:
docker-compose up
It will take a few minutes to build PgDog from source and launch the containers. Once started, you can connect to PgDog with psql (or any other PostgreSQL client):
PGPASSWORD=postgres psql -h 127.0.0.1 -p 6432 -U postgres
The demo comes with 3 shards and 2 sharded tables:
INSERT INTO users (id, email) VALUES ( 1 , ' [email protected] ' ); INSERT INTO payments (id, user_id, amount) VALUES ( 1 , 1 , 100 . 0 ); SELECT * FROM users WHERE
... Read full article.