How to Install PostgreSQL on Linux (Ubuntu) Using Apt

Installing PostgreSQL on Ubuntu

• 💡 The video guides users through installing PostgreSQL on Linux, specifically Ubuntu, using the official PostgreSQL website and the apt package manager.
• 🎯 The primary method demonstrated is sudo apt install postgresql, which is a straightforward approach for Debian-based systems.

Verifying the PostgreSQL Installation

• 🔍 After installation, the video shows how to check the PostgreSQL service status using sudo systemctl status postgresql.
• ⚠️ If the service is inactive or disabled, commands like sudo systemctl start postgresql and sudo systemctl enable postgresql are provided to activate and enable it.
• 📈 The PostgreSQL version can be confirmed by running postgresql --version.

Accessing the PostgreSQL Shell

• 🔑 To interact with the database, users need to switch to the postgres user using sudo -i -u postgres.
• 💬 From the postgres user's shell, the psql command opens the PostgreSQL interactive terminal, allowing users to execute SQL commands.
• 🚪 Exiting the psql shell is done by typing \q.