How to calculate the distance between Kyoto and Tokyo using a PostgreSQL database?

Let's create a Docker container named "some-postgis" running PostgreSQL with PostGIS extensions enabled, and sets the password for the PostgreSQL database to "mysecretpassword".

The container will run in the background until stopped or removed.

docker run --name some-postgis -e POSTGRES_PASSWORD=mysecretpassword -d postgis/postgis

Unable to find image 'postgis/postgis:latest' locally
latest: Pulling from postgis/postgis
04e7578caeaa: Pull complete
20333c6f31ac: Pull complete
186040651c97: Pull complete
c2e240f76f8f: Pull complete
213c8153be0a: Pull complete
15c269e14d99: Pull complete
c21b8876507e: Pull complete
e397c567af1a: Pull complete
0322ead07fa8: Downloading [=========================>                         ] …

container database docker extensions find howto image latest name password postgres postgresql run running sql