Very, very high-level quick-start guide to get started using PostgreSQL.
Installation Debian: sudo apt install postgresql Mac: brew install postgresql Create Databases and Users Create user:
sudo su postgres create role Alice LOGIN CREATEDB Create database
do it as Alice createdb somedatabase psql somedatabase Password and Access Control login a database as Alice
\password Edit /etc/postgresql/9.5/main/pg_hba.conf for access control. The file is pretty self-explainatory.