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 my Ubuntu tutorial, your credentials will be sa and your chosen password. If you did the Windows installation, your username will be postgresql with the password you chose. Also, if you did the Windows installation, your Host name/address should be localhost. pgAdmin might find your local database automatically. In that case, just enter your password when opening the server node:

Once you hit Save, pgAdmin should connect and you will know whether you did everything correctly during the installation of PostgreSQL.