Installing pgAdmin
Now, in our Windows host we will need to install some management tools. There are plenty of management systems for PostgreSQL that run on various systems, but I have chosen the popular pgAdmin. You can download the latest version of pgAdmin (pgAdmin 4 at the time of writing) from the PostgreSQL website (https://www.postgresql.org/ftp/pgadmin3/pgadmin4/v1.1/windows/). Simply download the exe file and run it. This installation is, again, a matter of clicking next and leaving all the defaults.
Once you have installed pgAdmin, open it, right-click on Servers in the top left corner, and go to Create | Server.... Enter a name for your server in the General tab and enter your credentials in the Connections tab. If you followed ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access