Hi everyone,
With ERPNext officially expanding and hardening its support for PostgreSQL, we wanted to align the developer tooling accordingly. Today, we are excited to introduce official, ready-to-boot PostgreSQL Single Node Environment (SNE) images to the Frappista container ecosystem!
While MariaDB has been the traditional backend for Frappe/ERPNext development containers, this new image makes spinning up a local Postgres development site completely frictionless.
These images boot a fully self-contained environment (running PostgreSQL 15, Redis, and Frappe/ERPNext in development mode) in just a few seconds.
Image Coordinates (Docker Hub)
-
PostgreSQL Backend:
vyogo/erpnext:sne-postgres-develop -
MariaDB Backend:
vyogo/erpnext:sne-develop
(Both images are built as multi-arch manifests supporting both AMD64 and ARM64 natively, so they run flawlessly on Apple Silicon Macs, Intel/AMD workstations, and ARM servers).
Quick Start
You can run the PostgreSQL-backed image using a single command (Docker or Podman):
docker run -d --name erpnext-postgres-sne \
-p 8000:8000 \
-p 9000:9000 \
-p 5432:5432 \
-e POSTGRES_PASSWORD=ChangeMe \
vyogo/erpnext:sne-postgres-develop
Port Breakdown:
-
8000: Access the desk athttp://localhost:8000(User:Administrator, Password:admin) -
9000: Maps Socket.io for real-time events and notifications. -
5432: Direct database access from your host machine (User:frappe, Password:ChangeMe, DB:frappe).
Watch it in Action:
Here is a quick walkthrough video demonstrating the container boot, initial Postgres setup, and accessing the ERPNext desk: https://youtu.be/u_Z_3-GVeXM/
What’s Next?
- Frappe Operator Integration: We are currently working on bringing full PostgreSQL support to the Frappe Operator shortly. You’ll soon be able to orchestrate PostgreSQL-backed Frappe and ERPNext deployments in Kubernetes with the same ease as SNE.
We’d love to get your feedback! Try it out and let us know how PostgreSQL is performing for your custom apps and workflows.