Crankshaft

Dockerized CARTO Spatial Analysis extension for PostgreSQL. For additional information on the package, see the original repository.

Code organization

• doc/ documentation
• src/ source code

• pg/ contains the PostgreSQL extension source code
• py/ Python module source code

• release released versions

Building and Running

To build:

docker build -f Dockerfile -t crankshaft .

To run:

docker run --user postgres -p 5433:5432 crankshaft /usr/lib/postgresql/10/bin/postgres -D /var/lib/postgresql/10/main -c config_file=/etc/postgresql/10/main/postgresql.conf

After running the above command, connect to the database by running:

psql -U postgres -h 0.0.0.0 -p 5433

or

psql 'postgres://postgres@127.0.0.1:5433/postgres'

To access psql directly on the image (assuming postgres is running):

docker ps
docker exec -it <id> bash
psql

The Crankshaft extension should be present on the database already. You can check by \dx inside of psql. If it is not, you can add it with:

CREATE EXTENSION crankshaft CASCADE;