There are a few ways of setting up PgAdmin4 you can download it from the official website pgadmin or you can set it up with homebrew. I like homebrew so we're going to do it that way!
Here's how you can do it too!
First, It's always a good practice to update Homebrew to ensure you get the latest versions of software.
brew update
Next we can install pgAdmin 4 using Homebrew by executing the following command:
brew install --cask pgadmin4
After the installation is complete, you can launch pgAdmin 4.
You might find it in your Applications folder, or you can start it using the Finder search (Cmd + Spacebar, then type "pgAdmin 4").
Connecting to your PostgreSQL Database
When you first open pgAdmin 4, you'll need to set a master password for the pgAdmin application itself. This is different from your PostgreSQL credentials.
To connect to your local PostgreSQL database, right-click on Servers
in the left-hand browser pane, and a dropdown will appear
Register > Server
and
Create > Server Group
for all intents and purposes we're going to create a new server group.
Select Create > Server Group
In the Create - Server Group
dialog, enter a name for the connection in the Name
field. Your new server group will come up in the left pane. Right click the server name you just created and click Register > Server
.
Make sure you give the server a name and then switch to the Connection
tab, and enter the following details, We're going to create a locally running postgreSQL database.
Hostname/address: localhost
Port: 5432 (default PostgreSQL port)
Maintenance database: postgres
Username: Your PostgreSQL SuperUsername
Password: Your PostgreSQL user's password
Note: You can save the password for ease of use later.
Remember to ensure that your PostgreSQL server is running when you try to connect via pgAdmin 4. If you face any issues with the connection, verify that PostgreSQL is active (using brew services list) and that the connection details in pgAdmin 4 are correct and that's it.
You can now use pgAdmin 4 to manage your PostgreSQL databases, create tables, run queries, and much more, all through a user-friendly interface.
Top comments (0)