Database Engineering
  • Need of Database
  • Database and Database Management System
  • What is Relational Database Model ?
  • Installing Postgresql
    • Installing PostgreSQL on Linux
    • Installing PostgreSQL on Windows
    • Installing PostgreSQL on Mac
    • Postgres in Docker
  • What happens during the initial installation ?
    • Roles, Users & Groups
    • More examples on Roles
  • Sample Databases
    • DVD Rental Database
  • Querying Data
    • SELECT Query
    • Column Aliases
    • Order By
    • SELECT DISTINCT
    • DB-TASK-001
  • Filtering Data
    • WHERE ?
    • AND Operator
    • OR Operator
    • LIMIT
    • FETCH
    • IN
    • BETWEEN
    • LIKE
    • SIMILAR TO
    • IS NULL
    • ESCAPE
    • DB-TASK-002
  • Entity Relationship Diagram
    • What is an ER Diagram ?
    • Entity
    • Identifiers
    • Relationship
    • Attributes
    • Cardinality
    • Entity Relationship Diagram Tutorial
    • DB-TASK-003
  • Joins
    • Joins
    • Joins With Employee and Departments
  • Joins on E-Commerce
Powered by GitBook
On this page
  • Step 1: Download the Installer
  • Step 2: Run the Installer
  1. Installing Postgresql

Installing PostgreSQL on Windows

PreviousInstalling PostgreSQL on LinuxNextInstalling PostgreSQL on Mac

Last updated 6 months ago

Step 1: Download the Installer

  • Go to the

  • Select Windows and download the installer.

Step 2: Run the Installer

  1. Open the downloaded file and follow the prompts.

  2. During installation:

    • Choose a directory for PostgreSQL (default is fine).

    • Set a password for the default PostgreSQL user (postgres). Remember this password!

    • Select the components you need. By default, everything essential is selected.

    • Choose a port (default is 5432). Keep this unless you have a specific reason to change it.

Step 3: Verify Installation

  1. Open pgAdmin (a graphical tool included in the installation) and connect using the password you set.

  2. Alternatively, open the command prompt and type

psql -U postgres

Explanation: psql is the command-line tool for PostgreSQL. It connects to the database using the username postgres.

PostgreSQL website.