📨
SlackClone
  • Introduction
  • Server
    • Server Introduction
    • Getting Started
      • Install .NET Core 3
      • Create a Project
      • Install Dependencies - Mongo
      • Install Dependencies - PostgreSQL
        • PostgreSQL Install - Windows
        • Connect to PostgreSQL DB - pgAdmin
    • API
      • Setup HotChocolate Server
      • Add Playground
      • Data Model - PostgreSQL
        • PostgreSQL Entities
        • Database Context
        • Queries
          • Filtering
          • Sorting
        • Mutations
        • Subscriptions
      • Data Model - Mongo
        • Mongo Entities
        • Queries
  • Authorization
  • Authentication
  • Error Handling
  • Testing
  • Backend Summary
  • Client
    • Client Introduction
    • Getting Started
      • Install Dependencies
      • Create Project
    • App
      • Routing
      • Queries
        • Pagination
        • Sorting
        • Filtering
      • Mutations
      • Subscriptions
      • Authentication
    • Frontend Summary
Powered by GitBook
On this page
  • Download PostgreSQL Installer for Windows
  • Install PostgreSQL step by step
  • Verify the Installation
  1. Server
  2. Getting Started
  3. Install Dependencies - PostgreSQL

PostgreSQL Install - Windows

PreviousInstall Dependencies - PostgreSQLNextConnect to PostgreSQL DB - pgAdmin

Last updated 5 years ago

We will be working with PostgreSQL the following guide walks you through getting a local install of the database up and running.

There are three steps to complete the PostgreSQL installation:

  1. Download PostgreSQL installer for Windows

  2. Install PostgreSQL

  3. Verify the installation

Download PostgreSQL Installer for Windows

First, you need to go to the download page of .

Second, click the download link as shown below:

It will take a few minutes to complete the download.

Install PostgreSQL step by step

Step 1. Double click on the installer file, an installation wizard will appear and guide you through multiple steps where you can choose different options that you would like to have in PostgreSQL.

Step 2. Click the Next button

Step 3. Specify installation folder, choose your own or keep the default folder suggested by PostgreSQL installer and click the Next button

Step 4. Select components to install and click the Next button

Step 5. Select the database directory to store the data. Just leave it by default or choose your own and click the Next button.

Step 6. Enter the password for the database superuser (postgres)

Step 7. Enter the port for PostgreSQL. Make sure that no other applications are using this port. Leave it as default if you are unsure.

Step 8. Choose the default locale used by the database and click the Next button.

Step 9. Ready to install PostgreSQL. Click the Next button to start installing.

The installation may take a few minutes to complete.

Step 10. Click the Finish button to complete the PostgreSQL installation.

Verify the Installation

There are several ways to verify the installation.

The quick way to verify the installation is through the psql program.

First, click the psql icon to launch it. The psql window command line will display.

Second, enter all the necessary information such as the server, database, port, username, and password. To accept the default, you can press Enter. Note that you should provide the password that you entered during installing the PostgreSQL.

Third, issue the command SELECT version(); you will see the result as follows:

Congratulation! you’ve successfully installed PostgreSQL database server on your local system.

Install PostgreSQL - download file
Install PostgreSQL - step 1
Install PostgreSQL - psql
Install PostgreSQL - Connect to PostgreSQL via psql
PostgreSQL installers on the EnterpriseDB