How To Install Pgadmin4 On Mac

In this post, You volition learn how to install PostgreSQL and pgAdmin on Macoperating system. pgAdmin is an administrative tool to manage your database, import and export data and write SQL queries.

Install PostgreSQL on Mac –

To installing PostgreSQL on Mac, we will use the Postgres.App. This is a open source Mac awarding for installing PostgreSQL and PostGIS extension for Geo data.

1. Visit the https://postgresapp.com/downloads.html and click on the download button to download the disk image file with .dmg extension.

2. Double click on the .dmg file and drag and drib information technology into the Applications folder.

three. Now, Go to your Applications folder on Mac and Double click on the Postgres icon to open information technology. Then click on Initialize to create and showtime the PostgreSQL database. You can too check the small elephant icon on the carte bar at top right to cheque if the database is running. By default postgreSQL creates a database for you with the name postgres.

four. If you want to include PostgreSQL command line tools then run the post-obit commands on your last. Copy the code as a unmarried line and paste it on the terminal and striking enter. Yous can also detect the code from here – https://postgresapp.com/

            sudo mkdir -p /etc/paths.d && echo /Applications/Postgres.app/Contents/Versions/latest/bin | sudo tee /etc/paths.d/postgresapp                      

5. The default settings of the postgres database is this –

Install pgAdmin on Mac –

Postgres.App does not include the pgAdmin tool. And then y'all have to download it yourself.

1. Get to the pgAdmin mac download page – https://www.pgadmin.org/download/pgadmin-four-macos/

2. Select the latest version and on the next folio click on the pgadmin .dmg file to download.

3. Double click the .dmg file and agree the terms. Then drag and drop the pgAdmin 4 app elephant icon to the Application folder.

4. Go to the Application folder and double click on the pgAdmin 4 icon to open it. Then click on the servers > PostgreSQL > Databases > postgres .If during the installation process, you have been asked to create a user and password then please do so. I accept done information technology before then it did not asked me for it.

5. To know how to use the pgAdmin, please read this mail that I wrote few days agone – How to utilize pgAdmin for PostgreSQL.

If y'all like this post and then please share it with others and subscribe to our blog beneath to learn more about SQL.

1. How to install PostgreSQL and pgAdmin on Windows.
2. How to use pgAdmin for PostgreSQL.
3. Create a Database and a Table in PostgreSQL.

Source: https://lifewithdata.com/2021/12/08/sql-tutorial-how-to-install-postgresql-and-pgadmin-on-mac/

Posted by: smithshord1965.blogspot.com

Share this post