DEV Community

Cover image for How to Install and Set Up PostgreSQL on a Linux Server (Ubuntu)
Kipngeno Gregory
Kipngeno Gregory

Posted on

How to Install and Set Up PostgreSQL on a Linux Server (Ubuntu)

Assignment 0 LUXDEV COHORT 4 JULY INTAKE

1️⃣ Step 1: Update Your System

sudo apt update
sudo apt upgrade -y
Enter fullscreen mode Exit fullscreen mode

2️⃣ Step 2: Install PostgreSQL

sudo apt install postgresql postgresql-contrib -y
Enter fullscreen mode Exit fullscreen mode

postgresql: Core PostgreSQL database system.
_postgresql-contrib: Additional useful tools and extensions.

3️⃣ Step 3: Verify PostgreSQL Installation

sudo systemctl status postgresql
Enter fullscreen mode Exit fullscreen mode

_To start/stop/restart PostgreSQL:

sudo systemctl start postgresql
sudo systemctl stop postgresql
sudo systemctl restart postgresql
Enter fullscreen mode Exit fullscreen mode

4️⃣ Step 4: Switch to PostgreSQL User

sudo -i -u postgres
Enter fullscreen mode Exit fullscreen mode

5️⃣ Step 5: Access PostgreSQL

psql
Enter fullscreen mode Exit fullscreen mode

To exit:
\q

6️⃣ Step 6: Secure PostgreSQL

\password postgres
Enter fullscreen mode Exit fullscreen mode

7️⃣ Step 7: Create a New Database

CREATE DATABASE myappdb;
CREATE USER myappuser WITH ENCRYPTED PASSWORD 'mypassword';
GRANT ALL PRIVILEGES ON DATABASE myappdb TO myappuser;
Enter fullscreen mode Exit fullscreen mode

8️⃣ Step 9: Test Connection Locally

psql -h localhost -U myappuser -d myappdb
Enter fullscreen mode Exit fullscreen mode

now you will have installed and configured PostgreSQL on your Linux server🙂

by Kipngeno Gregory

Top comments (1)

Collapse
 
gregory42266270 profile image
Kipngeno Gregory •

in need of the docker version installation ? 😊
I'm here