₹200 free credit when you verify after signup, plus your first recharge doubled. Credit after KYC, valid 15 days (extendable once). Bonus on first top-up of ₹500+, max ₹50,000, expires after 120 days. Promotional credit is never refunded as cash. Offer terms
Databases & data · BMH Apps

Host pgAdmin in India, in one click

pgAdmin is the standard web interface for managing PostgreSQL: browse tables, run queries, import and export data and manage users.

Needs the Starter plan or higher, from ₹139 a month before GST. HTTPS, your own domain and a GST invoice included. Hosted in Noida.

What people use it for

pgAdmin on your own app server

  • Run SQL against your app database from the browser
  • Inspect data while debugging
  • Import a CSV or a dump
  • Manage database roles
After you click Install

What happens

Install starts pgAdmin on HTTPS and saves a generated login email and password under Login details in the panel. Then register your database with the connection details the panel shows for it.

  • Its own address under apps.bookmyhost.com, on HTTPS from the first minute
  • Any passwords it needs are generated and saved under Login details, so you can view them again
  • Runs on a private app server that never sleeps; no SSH or Docker needed
  • Logs, restart and your own domain from the BookMyHost panel

About pgAdmin

pgAdmin 4 is the management console for PostgreSQL, built by the PostgreSQL community and released under the PostgreSQL licence. The web version gives you a tree of servers, schemas and tables, a query tool with explain plans, a graphical way to import and export CSV, a backup and restore dialog, and a place to manage roles and grants.

The behaviour that confuses new users is that pgAdmin doesn't create connections for you. It starts empty. You register each server with its host, port 5432, database and user, and from then on pgAdmin stores that list, your saved queries and your settings in its own small SQLite file under /var/lib/pgadmin. The login email and password come from PGADMIN_DEFAULT_EMAIL and PGADMIN_DEFAULT_PASSWORD. Look under Login details on the app page in the panel first; if they are not there, set those two variables yourself.

Two cautions from experience. First, pgAdmin lets you run DELETE and DROP just as easily as SELECT, with auto-commit on by default, so do the risky work in a transaction block. Second, its backup tool uses the pg_dump that ships inside the pgAdmin image, which can be older or newer than your server. A version mismatch gives an error; use a dump command from your own app in that case.

Set up pgAdmin on BMH Apps

  1. Install and sign in. Install pgAdmin from the store, then read the generated email and password under Login details and sign in.
  2. Register the server. Right-click Servers, Register, Server. Enter the PostgreSQL host name from the database's page in the panel, port 5432, the database name and the user.
  3. Run a read-only query. Open the Query Tool and run a SELECT with LIMIT. Look at the Explain tab if a query is slow.
  4. Take a dump. Right-click the database, Backup, and save a custom-format file. Then download it and store a copy in BookMyHost S3.

How big a plan pgAdmin needs

WorkloadPlanNote
Occasional admin work by one or two peopleStarterpgAdmin is mostly idle between queries.
Large imports or exports and several people at onceProBig CSV jobs and result grids use memory in the browser session on your server.
Smallest plan for pgAdmin

Starter · ₹139/month

1 vCPU, 1 GB RAM and 20 GB disk, up to 2 apps. Run pgAdmin next to your own code on the same server. Monthly, prices before 18% GST.

Install pgAdmin

FAQ

pgAdmin hosting questions

Is it safe to expose pgAdmin?

It is behind HTTPS and a generated password. Use a strong password, and stop the app from the panel when you do not need it.

Why is my server list empty?

pgAdmin never discovers servers by itself. Register each one with its private host name, port and credentials.

Can I reach a database on another provider?

Yes, if pgAdmin can connect to its host and port and the database allows your app server's address. Most managed databases need an allow-list entry.

Is it safe to leave running?

Stop it when you are not using it. A management console with direct access to production data is a bigger risk than the few MB it saves.

How does one-click install work?

Choose an app from the store, pick the app server to put it on, and click Install. It gets its own HTTPS address, its passwords are generated for you and shown once, and it is live in a minute or two.

Run pgAdmin in India

Create an account, complete eKYC once and install it in one click. Every new account starts with ₹200 of free credit.

Install pgAdmin
Get the app

Your cloud, in your pocket

Start, stop and reboot servers, open the console, watch live graphs, top up the wallet and chat with support, from the free BookMyHost Cloud app.

Get BookMyHost Cloud on Google Play iPhone app coming soon

See everything the app does →