Instructions for installing and running PostgreSQL locally

install-postgres.md

How to install + setup PostgreSQL (on Debian Linux)

Following steps are for starting a PostgreSQL database locally on your machine and accessing it as a postgres user.

Install the package

sudo apt install postgresql

• note down the version with psql --version

Start the service

sudo systemctl start postgresql (Normal debian using systemd)

sudo service postgresql start (WSL2 without systemd)

Acces the SQL prompt as the postgres user

sudo -u postgres psql

Set a password for the postgres user

\password postgres

Then, save the password you chose to your config files.

Create/remove database

sudo -u postgres createdb NAME

sudo -u postgres dropdb NAME