# How to access phpPgAdmin in cPanel?

> Canonical: https://jethost.com/kb/how-to-access-phppgadmin-in-cpanel/ · Last modified: 2026-10-21T11:11:49+00:00

**phpPgAdmin** is the web-based tool for managing your PostgreSQL databases from the browser – the PostgreSQL equivalent of phpMyAdmin. It’s built into cPanel, and it’s where you go to browse data, run queries, and back up or restore a database. This guide shows how to open it and what you can do inside. phpPgAdmin comes with every [JetHost web hosting plan](https://jethost.com/web-hosting/).

## Open phpPgAdmin in cPanel

1. Log in to cPanel.
2. In the **Databases** section, click **phpPgAdmin**.
3. It opens ready to use, with your PostgreSQL databases listed in the left sidebar.

![Access phpPgAdmin](https://jethost.com/wp-content/uploads/2026/10/access-phppgadmin.png)If you don’t have a database yet, create one first with the [PostgreSQL Database Wizard](https://jethost.com/kb/create-postgresql-database/), then come back here to manage it.

## What you can do inside

- **Browse and edit data** – expand a database, open a table, and view, add, or change rows.
- **Run SQL** – use the **SQL** window to run your own queries.
- **[Export and import](https://jethost.com/kb/postgresql-backup-restore/)** – back a database up to a file, or restore one.
- **Manage structure** – create or drop tables, and tidy up objects you no longer need.

## Finding your way around

The left sidebar is a tree: your server, then each database, then its schemas and tables. Click down into it to reach what you want, and the actions along the top – such as **SQL**, **Export**, and **Import** – apply to whatever you’ve selected. Most PostgreSQL objects live under the **public** schema, so if you can’t find a table, expand that schema first. If an action seems to target the wrong thing, check what’s highlighted in the tree – that’s almost always the reason.

## JetHost Experts Tip

Before editing data or running a query that changes rows, take a quick export first. phpPgAdmin applies changes immediately with no undo, so a fresh backup is your safety net if something doesn’t go to plan.

## If phpPgAdmin asks you to sign in

Most of the time phpPgAdmin opens straight from cPanel with your databases already listed. If it ever shows a login prompt, sign in with your **PostgreSQL database username and password** – the ones you set when you created the database, not your cPanel login. Remember that the username carries your account prefix, so enter it in full. If the login is refused, the usual cause is a mistyped password or a missing prefix, so check those first before anything else.

## Need more help?

Not sure which option you need in phpPgAdmin? Open a ticket through **Client Area → Support** and our team will guide you.
