Setup Postgres¶

Installation¶

The quickest way to get Postgres up and running on the Mac is using Postgres.app.

On Ubuntu you can use apt.

sudo apt update
sudo apt install postgresql

Postgres.app should make psql available for the user who installed it.

psql

Enter the following:

CREATE DATABASE "my_database_name";

If you prefer a GUI, pgAdmin has an installer available.

Using psql:

sudo su postgres -c psql

Enter the following:

CREATE DATABASE "my_database_name";

DEB packages are available for Ubuntu.

Piccolo is tested on most major Postgres versions (see the GitHub Actions file).