This document summarises my learnings from setting up a postgres container on arch linux for dev - no prod. I will also touch on using psql and vim-dadbod-ui to interface with the DB. There's also dbeaver
, which is the shotgun epquivalent of DB tools (= fire and forget, easy to use), which I won't cover here for that reason.
My goal was specifically to set up a local dev env with the limited knowledge I have of docker containers and DBMS in general.
I did not want to install postgres on my system directly, although I could run it on demand and kill when done, it seemed cleaner to have a layer of separation.
Instead I only installed postgresql-libs
(aka libpq
) solely for psql
, which is essentially a postgres read-eval-print-loop (REPL).