From the list, select the server and enter the administrator user's password that was created during installation. To ensure that PostgreSQL has been installed and is functioning correctly, you can launch the graphical utility, PgAdmin 4, after installation. Finish installation Checking functionality Click on the "Finish" button to close the installer. Once the installation is finished, a window will appear indicating that PostgreSQL has been successfully installed. Starting Install Finishing up the installation process PostgreSQL's installation may take some time, depending on the server's technical specifications. Choosing locale Initiating installation processĪfter we have entered all the necessary parameters, tap "Next" button. Selecting application port Screenshot №6. We will keep the default settings for both. This password will enable you to access the PostgreSQL database.Īside from the password, during the installation process, you will be prompted to specify the port on which the application will run, as well as the locale. In the upcoming screen, you will be required to create a password for the default PostgreSQL account. Screenshot №3.Choosing components Setting parameters The pgAdmin 4 graphical administration utility.For this particular installation, we will only choose the essential components: By default, all components are selected however, we can customize this selection based on our requirements. In the following screen, there is an option to choose the components to install. Choosing installation folder Choosing components The installation directory is usually set to "C:\Program Files\PostgreSQL\" by default, however, it is possible to specify a different directory. N the following screen, we have to select a directory for the installation of PostgreSQL.
Starting installation Choosing the installation location After starting the installation, a welcome window will appear, and we need to click the "Next" button. Begin the installation processįollowing that finish download process we run it. The appropriate version of the installation file for our operating system can be downloaded from the official site " ". The initial step would be to download the installation files. License included Try Windows Server Download distribution kit Windows Cloud Servers Create VMs in the cloud based Windows Server OS It is not a difficult task to install it and by few steps below, you can successfully install it yourself. It also provides high performance,reliability and multithreading technologies. It has high power and scalability, and supports many features such as transactions, stored procedures and triggers, full-text search, geospatial data, JSON, and other. The next post in the series will be how to install and use PostGIS with Postgres via pgAdmin 4.Ĭlick here for more tutorials related to PostgreSQL.PostgreSQL is an open-source database management software that combines the capabilities of object-oriented and relational approaches to data storage. Using pgAdmin 4, you can now explore your PostgreSQL server that hosts your database.For Windows computers, you will need to create a password for this default user (remember to keep the password). For PostgreSQL servers, there are always a default user called “postgres”. It will named something like PostgreSQL 9.6. On the left hand Browser, click the + next to Servers, and it will show the server. There will be a default PostgreSQL server on your system.pgAdmin 4 may take some time to launch, and when it does, it will look something like:.When it’s done installing, you can select Launch pgAdmin 4 and Finish.I keep it in the default/suggested folder. It will then ask where you want to save your program files for pgAdmin 4.The wizard will then ask you to read over the license agreement.Part 2: How to Install pgAdmin 4 for Windows 10
You can read more about it at the pgAdmin website. It is an alternative to the terminal or pSQL console. PgAdmin 4 is graphical interface for interacting with PostgreSQL databases. This tutorial leaves off from Part 1: How to Install PostgreSQL on Windows 10. This is the second in the series, and this is on how to install pgAdmin 4 for Windows 10.
Note: I also use Windows 10 and hosted my Postgres database on Digital Ocean, so I will be covering all the tricky parts I ran into! For one of my apps, I was responsible for the database, and there were some tricky things with Postgres! This post is part of a tutorial series on how to use Postgres!