Mar 21 2025
technical howto

How to set up PostgreSQL on Arch Linux

About setting up PostgreSQL on Arch Linux.

TL;DR 🔗︎

1. Install the postgresql package.

sudo pacman -S postgresql

2. Intialize a data database as the postgres user.

sudo -i -u postgres
[postgres@archlinux ~]$ psql
postgres=> initdb --locale=C.UTF-8 --encoding=UTF8 -D '/var/lib/postgres/data'

4. Enable and start the postgresql service.

sudo systemctl enable postgresql
sudo systemctl start postgresql

5. Enter psql and create a new database with your user.

sudo -u postgres psql
postgres=# create database MYUSER;
postgres=# create user MYUSER with password 'MYPASSWORD';
postgres=# grant all privileges on database MYUSER to MYUSER;

More reading