Setup Postgres

Installation

Mac

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

Ubuntu

On Ubuntu you can use apt.

sudo apt update
sudo apt install postgresql

Creating a database

Mac

psql

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

psql

Enter the following:

CREATE DATABASE "my_database_name";

pgAdmin

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

Ubuntu

psql

Using psql:

sudo su postgres -c psql

Enter the following:

CREATE DATABASE "my_database_name";

pgAdmin

DEB packages are available for Ubuntu.


Postgres version

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