PostgreSQL: Installing pagila

Step by step: How to install the pagila database in a local postgres cluster.

2023-08-06 less than 1 minute read

postgres fanatic
command line aficionado
macOS/darwin (Unix) user

What’s pagila?

pagila is a sample DVD rental database for PostgreSQL. See the pagila repo for more information.

The installation directions in the repo are tailored for Docker usage.

This gist shows the shell and psql commands to install pagila on a local postgres cluster:

Discuss - Comments and questions are (more than) welcome.

2023-10-08 less than 1 minute read

As much as I like the idea of bang history expansion in the shell, I probably end up escaping “!” much more than I use it.

2023-10-06 2 minute read

I’ve seen this mistake too often to remain silent any longer.

2023-10-05 less than 1 minute read

2023-09-30 1 minute read

Seems like this should be easy.