PostgreSQL Installation

PostgreSQL Getting Started / Installation

PostgreSQL can be installed on Windows, Linux, and macOS. Below is a beginner-friendly step-by-step guide to get you started.

1️⃣ Check System Requirements

• OS: Windows / Linux / macOS

• Disk Space: ~200 MB (more for data)

• RAM: Minimum 1 GB (recommended 2 GB+)

2️⃣ Install PostgreSQL

 Windows Installation

1. Visit the official PostgreSQL website
   👉 https://www.postgresql.org/download/windows/

2. Download the EnterpriseDB installer

3. Run the installer and select:

   • PostgreSQL Server

   • pgAdmin 4

   • Command Line Tools

4. Set:

   • Superuser password (important)

   • Default port: 5432

5. Finish installation

✅ pgAdmin will open automatically after installation.

🐧 Linux Installation (Ubuntu/Debian)

Start and enable PostgreSQL:

Check version:

🍎 macOS Installation

Option 1: Using Homebrew

Option 2: Postgres.app

• Download from 👉 https://postgresapp.com

• Drag to Applications and launch

3️⃣ Access PostgreSQL

Using Command Line (psql)

Linux:

Exit:

Using pgAdmin (GUI Tool)

Steps:

1. Open pgAdmin 4

2. Create Server → Register

3. Enter:

   • Host: localhost

   • Port: 5432

   • Username: postgres

   • Password: (set during install)

4️⃣ Create Your First Database

Connect to database:

5️⃣ Create Your First Table

Insert data:

6️⃣ Basic PostgreSQL Commands

7️⃣ Common Beginner Issues & Fixes

 1.psql not recognized
 2.Add PostgreSQL bin folder to PATH

 3.Password authentication failed
 4. Reset postgres password or check pg_hba.conf

 5.Port 5432 already in use
 6.Change port during installation