Getting postgresql running on Arch Linux

postgresql_plus_arch-linux.md

Setup Postgresql

run postgresql with systemctl

Install postgres

latest

sudo pacman -S postgresql

specific version

find version & build from source

Check version

postgres --version

Confirm psql is not running

sudo systemctl status postgresql --> should not be running

Login as the postgres user

Note: always do this any time you are doing any type of admin work on psql

sudo su - postgres

Initialize data directory

Note: default db for psql is /var/lib/postgres/data

initdb --locale en_US.UTF-8 -D /var/lib/postgres/data

Logout of postgres user

exit

Confirm psql is still not running

sudo systemctl status postgresql --> should not be running

Start psql

sudo systemctl start postgresql

Confirm psql is running

sudo systemctl status postgresql --> should be active

Create user

Log into postgres

sudo su - postgres

Create a new user

Note: user can be called anything however if you create a PostgreSQL user with the same name as your Linux username, it allows you to access the PostgreSQL database shell without having to specify a user to login (which makes it quite convenient).

createuser --interactive

• Enter name of role to add: MY_LINUX_USERNAME
• Shall the new role be a superuser?: y

Logout of postgres user

exit

Restart psql

sudo systemctl restart postgresql

Confirm psql is running

Note: can see that it was restarted by looking at the timestamp on the Active field

sudo systemctl status postgresql

This is well-documented and working like a charm, thank you kindly for putting this together!

Thank you!

Thanks a lot!

Really straight foward!

that's was helpful

Thank you, nice

Thank you, great cheatsheet

Truely legend

This is excellent! Thank you very much. It is clear, correct, and much easier to understand than the Arch Linux wiki page for postgresql.

This is a good writing and saves a lot of time, thanks.

G.O.A.T.

worked thanks

Thank you.

Thank you.

cheers ya legend

Thank you, but before starting PostgreSQL with systemctl start postgresql, you should initdb -D /var/lib/postgres/data*.

But anyway, thank you!

*source

The guide explicitly states to do this. See the step Initialize data directory.

Thank you, but before starting PostgreSQL with systemctl start postgresql, you should initdb -D /var/lib/postgres/data*.
But anyway, thank you!
*source

The guide explicitly states to do this. See the step Initialize data directory.

Ops, sorry! I will erase the comment--- sorry for the trouble.

Thank you, but before starting PostgreSQL with systemctl start postgresql, you should initdb -D /var/lib/postgres/data*.
But anyway, thank you!
*source

The guide explicitly states to do this. See the step Initialize data directory.

Ops, sorry! I will erase the comment--- sorry for the trouble.

No worries at all 👍

...thank you very much

thanks!

Ty bro

THANK YOU SOOO MUCH!!!!!!

Exactly what I needed, thank you!

Without you, I would never find it, thank you

Such a simple and well written set of instructions, thank you very much, friend!!!

Thank you! I feel like the arch wiki should point to this

Is there not a command pg_createcluster on arch linux?

that was smooth thank you !