Open Menu dzosoft
Close Menu dzosoft

   ALL ABOUT COMPUTER SCIENCE AND TECHNOLOGY


                             




Release your testosterone and observe the extreme increase in muscle mass.

Publish perfectly-optimized content in 1-click









 
 
 

How to install PostgreSQL on Windows step-by-step

 
   Although PostgreSQL was initially developed for UNIX-like platforms, version 7.1 has created a version that
can be compiled, installed and run on Windows operating systems. In this article we will see how to install PostgreSQL
in a Windows environment.
   With version 14.1, PostgreSQL made available a native version for Windows with an installer for both the client and the server,
while before version 8.0 Windows users were forced to install additional software to support some features present only on based
systems on UNIX.
At the time of writing this article (March 2022) PostgreSQL has released version 14.2
 

Step 1:

 

Use the Windows installer

 
Open the page of the official PostgreSQL site:http://www.postgresql.org
 
How to install PostgreSQL on Windows step-by-step
 
Click on Windows.
 
How to install PostgreSQL on Windows step-by-step
 
Click on Download the installer from EnterpriseDB for all supported versions, which opens the page http://www.enterprisedb.com/products-services-training/pgdownload#windows
 
How to install PostgreSQL on Windows step-by-step
 
    Click on the button labeled Win x86-64 if you have a 64-bit operating system. The postgresql14.2-1-windows-x64.exe file of about 288 Mb is downloaded.
 

Step 2:

   Double-click the postgresql-14.2-1-windows-x64.exe file to start the installation
Click Next at the welcome window.
 
How to install PostgreSQL on Windows step-by-step
 
Specify the installation directory. That proposed is: C:\Program Files\PostgreSQL\14
 
How to install PostgreSQL on Windows step-by-step
 
Select the component you want to install
 
How to install PostgreSQL on Windows step-by-step
 
Specify the directory where the data will be saved: C:\Program Files\PostgreSQL\14\data
 
How to install PostgreSQL on Windows step-by-step
 
   Specify the password of the superuser user. The superuser user is a database user who has permissions to create and manage databases on the server.
PostgreSQL accounts are used by clients to connect to the database and PostgreSQL itself manages the authentication.
 
How to install PostgreSQL on Windows step-by-step
 
Select the port the server is listening on. The default is 5432.
 
How to install PostgreSQL on Windows step-by-step
 
Select the locale configuration used by the database.
 
How to install PostgreSQL on Windows step-by-step
 
Click Next
 
How to install PostgreSQL on Windows step-by-step
 
Click Next
 
How to install PostgreSQL on Windows step-by-step
 
Wait for the installation to be completed.
 
How to install PostgreSQL on Windows step-by-step
 
   Remove the check mark on the use of StackBuilder, which is used to download and install additional tools, drivers and applications with
respect to the default PostgreSQL installation. PostGIS is one of them, for example.
 
How to install PostgreSQL on Windows step-by-step
 
PostgreSQL is created as a Windows service, which is automatically launched when Windows starts.
 
How to install PostgreSQL on Windows step-by-step
 
The PostgreSQL 14 folder is created in the Windows Start menu programs.
 
How to install PostgreSQL on Windows step-by-step
 
 

Step 3:

 

Connect to the PostgreSQL database with pgAdmin 4

 
Opening the Windows Start menu, under PostgreSQL 14, there are the following entries:
  • Application Stack Builder
  • Installation notes
  • pgAdmin 4
  • pgAdmin Documentation
  • postgresSQL Documentation
  • postgresSQL release notes
  • Reload Configuration
  • SQL Shell
  • Click on pgAdmin 4 to launch the graphical client for accessing the database.
     
    How to install PostgreSQL on Windows step-by-step
     
    Enter the password chosen in the installation step
     
    How to install PostgreSQL on Windows step-by-step
     
    Right click to create your database
     
    How to install PostgreSQL on Windows step-by-step
     
    in the folder C:\Program Files\PostgreSQL\14\doc you will find documentation to deepen the learning of the database
    Enjoy


    It might also interest you


    How to install Oracle Database 19c on Windows


    Leave comment
              

    Save nickname and email in this browser for the next time.



    Loading...     
    close publicity
    Japanese ritual of tranquility and... slim figure!