Contact us...Newsletter
dzosoft.com - How to do it ?
dzosoft- order by asc dzosoft- order by desc

 
 
 

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
    dzosoft
    WavePad
    Car Rental France
    Reviews of dzosoft.com   Copyright © 2022  -  dzosoft.com  All rights reserved.  
    dzosoft- How to do it ?
    What they are cookies
    Like most websites, we use data file small
    dimensions that are saved on your computer, tablet, mobile phone or other device
    Mobile (collectively referred to as 'device') to record certain data whenever
    login or interact with our sites, services, apps, messaging systems
    and strumenti.I names and specific types of cookies used can change over time.
    To help you better understand the rules and \ 'use of such technology, the following are
    some terms and their definitions:
    Cookies: small text files (usually formed by letters and numbers) that are saved
    in memory of the browser or the device when you visit a website or display a message.
    Cookies enable a website to recognize a particular device or browser. There
    different types of cookies:
    Session cookies expire at the end of the browser session and allow us to
    connect your actions during that specific session.
    Persistent cookies are instead stored in your device even after the end
    the browser session and let you remember your preferences or actions at multiple sites.
    First-party cookies are set by the site you're visiting.
    The third-party cookies are set by a third party site than the site you are visiting.
    Cookies can be disabled or removed using the tools available in most
    browsers. The cookie preferences must be set separately
    for each browser used, because each offers features and specific options.
    dzosoft.com - How to do it ?
    Licenza Creative Commons
    How to do it ?    - download & install software     is licensed under license Creative Commons Attribution - Non-commercial - Share alike 4.0 International.