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).