Advance

PostgreSQL installation tutorial on Windows Server 2016

PostgreSQL installation tutorial on Windows Server 2016

PostgreSQL installation tutorial on Windows Server 2016. In this article, we want to be with you on how to install PostgreSQL on Windows Server 2016.

 

What is PostgreSQL?

PostgreSQL is a standard, flexible database that uses SQL language to distribute and describe data. This database, sometimes called Postgres, is controlled and developed by a team of the same name. Currently, this database is also used in small and large projects, and because of its flexibility and freeness, it has attracted many enthusiasts.

PostgreSQL has various versions that can be installed on Windows, Linux and even MacOS.

Join us in this article with how to install PostgreSQL on Windows Server 2016 with PGadmin.

 

PostgreSQL installation tutorial on Windows Server 2016

1- First, enter your Windows Server 2016 environment.

2- Then download the PostgreSQL package for Windows via the following link.

Download PostgreSQL for Windows

 

PostgreSQL installation tutorial on Windows Server 2016-1

 

Note that after clicking on the download link on the PostgreSQL site, you will be asked for the Windows version, which you must specify exactly the 32-bit or 64-bit operating system and architecture.

 

PostgreSQL installation tutorial on Windows Server 2016-2

 

3- After downloading, double-click on the downloaded file to start the installation process.

After starting the installation process, click Next.

 

PostgreSQL installation tutorial on Windows Server 2016-3

Recommended Article: Ways To Set Up SSH Keys on Debian 10

4- In this section, you must select the address of the PostgreSQL storage and installation path and click Next.

 

PostgreSQL installation tutorial on Windows Server 2016-4

 

5- In the next step, you have to select the desired components and click Next.

 

PostgreSQL installation tutorial on Windows Server 2016-5

 

Note that if you need pgadmin for web access to PostgreSQL, you must select it at this stage.

6- After selecting the components in this step, specify the path for storing data or databases and click Next.

 

PostgreSQL installation tutorial on Windows Server 2016-6

 

7- In the seventh step, you must enter a password for Superuser and click Next.

 

PostgreSQL installation tutorial on Windows Server 2016-7

 

8- In this section, enter the PostgreSQL communication port and click Next.

9- In the last section, select the desired TimeZone of the system and click Next.

 

PostgreSQL installation tutorial on Windows Server 2016-8

 

Note: Note that the port, for example in this tutorial 5445, must be open in the Windows Firewall.

If you need information to work with Windows Firewall, learn how to open the port in Windows Firewall.

Note: It is recommended that you set this option to Default Locale to set the date and time for your Windows.

10- Finally, a summary of the settings you want to display is displayed. If confirmed, click Next to start the installation process.

 

PostgreSQL installation tutorial on Windows Server 2016-9

 

11- After copying the files and its settings, the installation of PostgreSQL is finished and you can use it.

 

PostgreSQL installation tutorial on Windows Server 2016-10

 

Access PostgreSQL

To access Pgadmin via the Start menu, search for pgAdmin and then click on it.
To access the Shell environment, search for SQL Shell in the Start menu and open it.

Dear user, we hope you would enjoy this tutorial, you can ask questions about this training in the comments section, or to solve other problems in the field of Eldernode training, refer to the Ask page section and raise your problem in it as soon as possible. Make time for other users and experts to answer your questions.

PostgreSQL installation tutorial on Windows Server 2016

Goodluck.

 

Also, see

Tutorial PostgreSQL installation Ubuntu 20.04

Tutorial install and use PostgreSQL on Ubuntu 18.04

We Are Waiting for your valuable comments and you can be sure that it will be answered in the shortest possible time.

Leave Your Comment

Your email address will not be published.

We are by your side every step of the way

Think about developing your online business; We will protect it compassionately

We are by your side every step of the way

+18054214518

7 days a week, 24 hours a day