PostgreSQL Setup

# PostgreSQL Setup

1. Checked if PostgreSQL is Installed

psql --version

If PostgreSQL is not installed, install it using sudo apt update sudo apt install postgresql postgresql-contrib

2. Create PostgreSQL Users and Databases

sudo -u postgres psql CREATE USER dev_user WITH PASSWORD 'dev_password'; CREATE USER prod_user WITH PASSWORD 'prod_password';

Create Databases

CREATE DATABASE dev_db OWNER dev_user; CREATE DATABASE prod_db OWNER prod_user;

List Users and Databases To list users: sudo -u postgres psql -c "\du" To list Databases: sudo -u postgres psql -c "\l"

3. Ensure Postgress starts on boot

sudo systemctl enable postgresql