PostgreSQL with astronomy extensions pg_sphere and pg_healpix.
The following command will start a Postgres 14 deamon with the pg_sphere module installed:
docker run --rm --name pg-docker -e POSTGRES_PASSWORD=<pass> -d -p 5432:5432 -v <path to store data locally>:/var/lib/postgresql/data astrodata/astro-psql:14
The database can be accessed via:
docker exec -it pg-docker psql -U postgres -d postgres
Create the pg_sphere extension with:
docker exec -it pg-docker psql -c "CREATE EXTENSION pg_sphere;" postgres -U postgres
docker exec -it pg-docker psql -c "CREATE EXTENSION pg_healpix;" postgres -U postgres
This fork uses the fix for PostgreSQL 12 by mdgomes.
For more information, have a look at https://pgsphere.github.io/ and https://github.com/akorotkov/pgsphere
The pg_healpix extension can be found here: https://github.com/d-i-an-a/pg_healpix
When upgrading from a previous version, it is very likely that the volume where the data are stored will be incompatible. You will have to dump and restore the database.
As always, make sure you have proper back-ups.