pgAdmin 4 lets you see your databases, tables and rows. One command installs it, and one form connects it.
Jo video mein bola, yahan nukte mein likha hai.
What I said in the video, written here as key points.
Dekh ke samajhna aasaan. Seeing it makes it easier to understand.
pgAdmin 4 is a visual manager for PostgreSQL. You can see your databases, tables and rows, and run queries, without typing every command.
Then open it from Applications.
Install it:
brew install --cask pgadmin4
Then open pgAdmin 4 from your Applications folder. The first time, it may ask you to set a master password. That is only for pgAdmin itself. On some Macs, you may need to right-click the app and choose Open the first time.
Right-click Servers, then Register, then Server. Fill these in and Save.
In pgAdmin, right-click Servers, choose Register → Server, and fill in: Name PostgreSQL; on the Connection tab, Host localhost, Port 5432, Username postgres, and the password you set (postgres if you followed the last video). Click Save. If the server opens and shows databases, it worked.
| Connection refused | PostgreSQL is not running. Run brew services list, then brew services restart postgresql@<version>. |
| Password authentication failed | Use the password you set for postgres. |
| Mac says the app cannot be opened | Right-click the app, choose Open, then Open again. |
Tell me exactly what the screen says. Ghabrana nahi.
brew services list, then brew services restart postgresql@<version>.postgres.Tell me in the comments. Milte hain agli video mein. Next: VS Code and Git.
Free SQL course and the Setup page, which maps every step. Join the WhatsApp Community, the Channel or Discord.