PostgreSQL Installation Guide for Windows

Downloading PostgreSQL

Google Search: Search for 'PostgreSQL download'.
First Link: Click on the first search result.
Download Options: Different options for various systems.
Select Windows: Choose Windows for the download.
64-bit Only: Ensure to download the 64-bit version as 32-bit is not supported.
- The download will start automatically after some time.

Run Setup: Double click on the setup file.
- Click on 'Next' through initial setup prompts.
Set Password: Input and remember the password for the database.
- This password is crucial for accessing the database later.
Default Port: Leave the default port number (5432) unchanged.
Database Cluster: Accept default settings for database cluster location.
- Click 'Next' and proceed with the installation.
Final Steps: Uncheck the option for 'Stack Builder' install and finish the setup.

Download pgAdmin: Search for 'pgAdmin 4' and select the latest version (e.g., August 15th release).
- The file size is 168 MB.
Run Setup: Double-click the downloaded pgAdmin executable to start the setup wizard.
- Accept the terms and click 'Next'.
- Accept default installation location (C drive).
Complete Setup: Proceed with the installation steps and finish.

Open pgAdmin: Search for 'pgAdmin 4' in the Windows search bar and open the application (not the installer).
Enter Password: Use the password set during PostgreSQL installation.
- Connect to the database server by inputting the same password.
Access Servers: You will see servers for PostgreSQL 12 and PostgreSQL 14. Use PostgreSQL 14.
- Enter the password again to connect.
Create Database: Right-click to create a new database. Further steps on creating tables and running queries will be discussed in the next session.