sakiladb/postgres

Postgres docker image preloaded with the Sakila example database (by way of jooq). See on Docker Hub.

By default these are created:

• database: sakila
• username / password: sakila / p_ssW0rd

docker run -p 5432:5432 -d sakiladb/postgres:latest

Or use a specific version of postgres (see all available image tags on Docker Hub.)

docker run -p 5432:5432 -d sakiladb/postgres:15

To verify that all is well:

$ PGPASSWORD=p_ssW0rd psql -h localhost -d sakila -U sakila -c 'SELECT * FROM actor LIMIT 5'
 actor_id | first_name |  last_name   |     last_update
----------+------------+--------------+---------------------
        1 | PENELOPE   | GUINESS      | 2006-02-15 04:34:33
        2 | NICK       | WAHLBERG     | 2006-02-15 04:34:33
        3 | ED         | CHASE        | 2006-02-15 04:34:33
        4 | JENNIFER   | DAVIS        | 2006-02-15 04:34:33
        5 | JOHNNY     | LOLLOBRIGIDA | 2006-02-15 04:34:33