PostgreSQL Installation

Why Install PostgreSQL?

To work with PostgreSQL locally on your machine, you’ll first need to set up the database engine and its tools. This installation enables you to create databases, run queries, and manage data right from your own device—without needing an external server.

Step-by-Step PostgreSQL Installation (for Windows)

1️. Download the Installer

• Open your browser and go to the official PostgreSQL website: https://www.postgresql.org/download/
• Choose Windows as your platform.
• Click on the link that takes you to the EDB Installer page.
• Choose the correct installer based on your operating system architecture (either 32-bit or 64-bit).
• Click the Download option and allow the process to finish before proceeding.

2️. Launch the Setup File

• Find the installer file you just saved—typically inside the "Downloads" directory.
• Launch the setup by opening the file with a double-click to begin configuring PostgreSQL.

3️. Choose Installation Folder

• The installer will suggest a default path like:
• C:\Program Files\PostgreSQL\version_number
• You can accept this or choose another location on your system.
• Click Next to proceed.

4️. Pick Required Components

You’ll be presented with a list of tools to install:

• Database Server – the core system.
• pgAdmin 4 – a graphical dashboard for managing your databases.
• Command Line Tools – optional tools for using SQL via terminal.

Make sure all are selected, then hit Next.

5️. Database Storage Location

• Choose a folder where your database files and data will be stored.
• It’s fine to stick with the default location.
• Continue by clicking Next.

6️. Create a Master Password

• Create a strong password for the "postgres" admin user.
• Use something secure and easy to remember, like: MyLocalDBpass1!
• Each time you connect to the database, this password will be used for authentication.

7️. Port Configuration

• The system asks for a network port number; the standard port is 5432.
• Unless you have a conflict, use the default and go forward.

8️. Choose Locale Settings

• You will be asked to pick a locale (language + region) for PostgreSQL.
• It defines number/date formats and encoding.
• Choose your region from the list, or leave the preselected option unchanged.

9️. Review Summary

• A final screen shows all selected options.
• If everything looks good, click Next.

Installation Begins

• The setup will now install PostgreSQL and its tools.
• This may take a few minutes—let it finish without interruption.

Installation Complete

• When installation completes, a confirmation screen will appear indicating success.
• pgAdmin may launch automatically, or you can open it from your Start menu.

You're Ready to Go!

PostgreSQL is now fully installed. In the next step, you can open pgAdmin 4 or the SQL Shell to start creating and managing your own databases.