Skip to content

PRJ2: pgAdmin Setup

pgAdmin lets you browse your deployed database in a web browser. Use it to check if your tables were created correctly, view data, and run test queries.

Step 1: Log in

Go to pgadmin.prod.fontysvenlo.dev and log in with:

Field Value
Email your team name + @prj2.fontysvenlo.dev (e.g., 2026-group01@prj2.fontysvenlo.dev)
Password the password you received from your lecturer

Step 2: Add the database server

After logging in, you need to connect pgAdmin to the database server. You only have to do this once.

  1. In the left panel, right-click Servers and select Register > Server...
  2. In the General tab:
    • Name: PRJ2 (or anything you like)

  3. Switch to the Connection tab and fill in:

    Field Value
    Host name/address postgresql.prj2-system.svc.cluster.local
    Port 5432
    Maintenance database your team name (e.g., 2026-group01)
    Username your team name (e.g., 2026-group01)
    Password same password as your pgAdmin login

    Tip

    Check Save password so you don't have to enter it every time.

  4. Click Save

Step 3: Browse your database

  1. In the left panel, expand: PRJ2 > Databases > your team name > Schemas > public > Tables
  2. Right-click any table and select View/Edit Data > All Rows to see its contents

Running SQL queries

  1. Click on your database in the left panel
  2. Click the Query Tool button in the toolbar (or right-click your database > Query Tool)
  3. Write your SQL and click the play button to run it
SELECT * FROM customers;

FAQ

I can't log in Double check that you are using the email format: your-team-name@prj2.fontysvenlo.dev (not just the team name).

"Connection refused" when adding the server Make sure the host is exactly postgresql.prj2-system.svc.cluster.local and the port is 5432.

I don't see my tables Your database resets on every deploy. If your init.sql has errors, your tables won't be created. Check your GitHub Actions for build errors, fix your SQL, and push again.

Can I break anything? No. Your database resets on every push anyway. Feel free to experiment.