Set up pgadmin Database Management Tool on Your Windows Box- Best Way to Access/Update your Postgres or Mysql Database

Here’s what you should do on his Windows box, start to finish.

1. Download pgAdmin 4 for Windows

1. On his Windows machine, open a browser and go to the official pgAdmin Windows download page:
   https://www.pgadmin.org/download/pgadmin-4-windows/​
2. Click the current Windows 64‑bit installer link (for example pgadmin4-x.y.z-x64.exe) and save it to his Downloads folder.

2. Install pgAdmin 4

1. In File Explorer, go to Downloads and double‑click the downloaded installer, e.g. pgadmin4-x.y.z-x64.exe.
2. If Windows asks “Do you want to allow this app to make changes…?”, click Yes.​
3. In the setup wizard:
   • Click Next on the welcome screen.
   • Accept the license and click Next.​
   • Leave the default install folder (e.g. C:\Program Files\PostgreSQL\pgAdmin 4) and click Next.​
   • Leave the default components selected and click Next.​
   • Click Install, wait for it to finish, then click Finish.​

He now has pgAdmin installed.

3. First‑time pgAdmin setup

1. Open pgAdmin 4 from the Start menu (search for “pgAdmin”).​
2. The first time it starts, it will prompt to set a master password.
   • This is just for storing saved connections; have him choose a password and click OK.​

He’ll now see the pgAdmin browser window with a “Servers” tree on the left.

4. Add your server (your Plesk/Postgres)

Before doing this, you need to have these these values from the postgres database you installed:

• Host name/address: your server’s public IP or hostname.
• Port: 5432 (or your custom Postgres port).
• Maintenance DB: usually postgres or the specific DB name you want him to connect to.
• Username: the Postgres user you created for him (e.g. gutcause_user).
• Password: the DB user password.

Then:

1. In pgAdmin, right‑click Servers (left panel) → Create → Server….
2. On the General tab:
   • Name: something friendly, like Donn Plesk Server.
3. Click the Connection tab and fill in:
   • Host name/address: your server IP or hostname.
   • Port: 5432 (or your actual Postgres port).
   • Maintenance database: postgres or the DB name you prefer.
   • Username: the DB user you gave him.
   • Password: the password you gave him.
   • Optionally check Save password so he is not prompted every time.
4. Click Save.

Now the server appears under Servers.

5. Connect and manage the DB

1. In pgAdmin’s left tree, double‑click the new server entry you just created.
2. If prompted for the master password, enter it.
3. Expand Databases → your_database_name → Schemas → public → Tables.
4. Right‑click on the DB or a table to:
   • View data (View/Edit Data),
   • Run queries (Query Tool),
   • Create/alter tables, indexes, etc.

6. Server‑side requirements (sometimes necessary – only if issues)

For the connection to work from your home/office Windows box, your server admin MIGHT need to:

• Ensure PostgreSQL is listening on an external interface:
  • In postgresql.conf, set listen_addresses = '*' (or at least your server IP).
• Allow your IP in pg_hba.conf with a line like:
  host all all username _IP/32 md5
• Make sure the server firewall allows TCP 5432 from the users IP.

Once that is done, your existing Postgres stays exactly as is, and the user can use pgAdmin over TCP.