Rethik
June 11, 2025, 6:47am
1
### Single Server Example
In this use case we have a single server with a static IP attached to it. It can be used in scenarios where one powerful VM has multiple benches and applications or one entry level VM with single site. For single bench, single site setup follow only up to the point where first bench and first site is added. If you choose this setup you can only scale vertically. If you need to scale horizontally you'll need to backup the sites and restore them on to cluster setup.
We will setup the following:
- Install docker and docker compose v2 on linux server.
- Install traefik service for internal load balancer and letsencrypt.
- Install MariaDB with containers.
- Setup project called `erpnext-one` and create sites `one.example.com` and `two.example.com` in the project.
- Setup project called `erpnext-two` and create sites `three.example.com` and `four.example.com` in the project.
Explanation:
Single instance of **Traefik** will be installed and act as internal loadbalancer for multiple benches and sites hosted on the server. It can also load balance other applications along with frappe benches, e.g. wordpress, metabase, etc. We only expose the ports `80` and `443` once with this instance of traefik. Traefik will also take care of letsencrypt automation for all sites installed on the server. _Why choose Traefik over Nginx Proxy Manager?_ Traefik doesn't need additional DB service and can store certificates in a json file in a volume.
Single instance of **MariaDB** will be installed and act as database service for all the benches/projects installed on the server.
Each instance of ERPNext project (bench) will have its own redis, socketio, gunicorn, nginx, workers and scheduler. It will connect to internal MariaDB by connecting to MariaDB network. It will expose sites to public through Traefik by connecting to Traefik network.
show original
We are referring the above doc for the MariaDB setup in frappe docker which is working fine. But we are required to use PostGres for which the documentation is not clear enough to complete the setup. We have tried but failed to complete. Also there isn’t any update for postgres in documentation than Mariadb. Is there any other documentation that could support for the setup?
Thanks in advance
ERPNext doesn’t have support for PostgreSQL, AFAIK.
dahaka
June 19, 2025, 9:31am
3
ERPNext doesn’t have support for PostgreSQL, AFAIK.
Correct, I tried to install it for ERPNext, it kinda worked but had some random errors, so definitely not meant to work in production
But I was able to get Postgres working with frappe docker following the setup instructions (so it works for bare frappe apps)