Deploy pgAdmin
Web admin and SQL tool for PostgreSQL, pinned version, data on a volume
Just deployed
/var/lib/pgadmin
Deploy and Host pgAdmin on Railway
pgAdmin is the most widely used open-source administration and development tool for PostgreSQL. From a web browser you can browse schemas, write and run SQL in the Query Tool, edit table data, design tables with the ERD tool, view query plans, and run backups and restores with the bundled PostgreSQL client tools.
About Hosting pgAdmin
This template runs pgAdmin 4 version 9.19.0 in server mode as one Railway service, built from a small GitHub repo around the official dpage/pgadmin4 image pinned by digest. Railway gives it an HTTPS domain and a health check on /misc/ping. A volume at /var/lib/pgadmin keeps the user accounts, saved server connections, preferences and query history across redeploys. At deploy you enter only the login email; the password is generated for you and shown in the service's Variables tab as PGADMIN_DEFAULT_PASSWORD. pgAdmin does not include a database: add connections to your own PostgreSQL servers after you log in, over Railway's private network or the internet.
Common Use Cases
- Browse, query and edit a Railway Postgres database from the browser, without exposing it through a public TCP proxy
- Run and explain SQL, inspect indexes and locks, and watch server activity on the dashboard
- Back up and restore databases with pg_dump and pg_restore, and manage roles, schemas and extensions
Dependencies for pgAdmin Hosting
- A PostgreSQL server to manage (versions 13 to 18 are supported), for example Railway's Postgres in the same project
- A volume for pgAdmin's own data (included in this template)
Deployment Dependencies
- pgAdmin container documentation: https://www.pgadmin.org/docs/pgadmin4/latest/container_deployment.html
- pgAdmin 4 releases: https://github.com/pgadmin-org/pgadmin4/releases
- Template source and changelog: https://github.com/aalfath/pgadmin-railway-template
Implementation Details
To connect to a Railway Postgres in the same project, deploy this template into that project and add a server in pgAdmin with:
Host: postgres.railway.internal
Port: 5432
Username: the value of PGUSER on the Postgres service
Password: the value of PGPASSWORD on the Postgres service
For a database in another project, use its public TCP proxy host and port instead.
The login email and password are applied only on the first boot, while the volume is empty. Change the password later from pgAdmin's user menu (Change Password). After 10 failed logins pgAdmin locks the account. Other pgAdmin settings can be added as variables named PGADMIN_CONFIG_ plus the setting name, for example PGADMIN_CONFIG_MAIL_SERVER for password-reset mail.
Updates arrive as "update available" notices from Railway when the template's repo moves to a new pgAdmin version; your data on the volume is kept and migrated on start.
Why Deploy pgAdmin on Railway?
Railway is a singular platform to deploy your infrastructure stack. Railway will host your infrastructure so you don't have to deal with configuration, while allowing you to vertically and horizontally scale it.
By deploying pgAdmin on Railway, you are one step closer to supporting a complete full-stack application with minimal burden. Host your servers, databases, AI agents, and more on Railway.
Template Content
PGADMIN_DEFAULT_EMAIL
Login email for the first pgAdmin admin account (any valid address, used only on first boot).
