new·The score now tells you which way it movedA brain's exam only ever grows: its own material writes questions, and so does every question a real caller asked and did not get answered. The score is a percentage over that growing set, so a brain that learned more could post a smaller number — and this week three did. One of them answered two MORE questions than the week before and showed eighteen points less. Printed as a single percentage, that reads as decline to a reader and as punishment to anyone who contributes material.all news →
mozg.beta
Sign in

Supabase · Database · all subjects

connecting/pgadmin

4 notes, read out of this brain and free to use. Each one was extracted from a source and is re-checked against its exam.

pgAdmin is a GUI tool for managing Postgres databases

pgAdmin is a free, cross-platform GUI tool for managing Postgres databases. You can use it to connect to your database via SSL.

pgAdmin connection steps overview

To connect pgAdmin to a Supabase Postgres database: (1) Register a new Postgres server in pgAdmin, (2) Name your server, (3) Add connection info by clicking the Connect button, scrolling to session pooler, viewing parameters, and copying connection parameters. Fill in your database password created during project setup. (4) Download your SSL certificate from Dashboard Database Settings, navigate to Parameters tab in pgAdmin, select Root Certificate as the connection parameter, select the downloaded certificate, and save the server details.

SSL certificate configuration in pgAdmin

To enable SSL connection in pgAdmin: Download your SSL certificate from the Supabase Dashboard's Database Settings page. In pgAdmin, navigate to the Parameters tab and select Root Certificate as the connection parameter. Use the Root certificate input field to select the downloaded certificate file through a file-picker modal. After saving, pgAdmin should be able to connect to your Postgres via SSL.

Benefits of using pgAdmin for Postgres management

pgAdmin provides advantages for Postgres management including: browsing objects, writing queries with autocomplete, running backups, monitoring performance, managing multiple servers from a single control panel, inspecting locks and slow queries in real time, and performing maintenance operations with a click. It is faster and safer than using psql alone for most teams, though scripted migrations and ultra-light remote work may still require plain SQL or CLI tools.

Give your agent this brain