search

rustprooflabs / pgosm-flex

PgOSM Flex provides high quality OpenStreetMap datasets in PostGIS (Postgres) using the osm2pgsql Flex output.
MIT License
101 stars 20 forks source link

docker image not utilizing external database #270

Closed dangelsaurus closed 2 years ago

dangelsaurus commented 2 years ago

Used docker image, with Postgres 15.1, postgis 3.3.2 with Ubuntu 22.04 installed on same machine...

The following was used to prepare the database

CREATE ROLE pgosm_flex WITH LOGIN PASSWORD 'pgosm_flex';
CREATE SCHEMA osm AUTHORIZATION pgosm_flex;
GRANT CREATE ON DATABASE postgres
    TO pgosm_flex;

and the following to prepare and run the docker file.

export POSTGRES_USER=postgres
export POSTGRES_PASSWORD=postgres
export POSTGRES_HOST=localhost
export POSTGRES_DB=postgres
export POSTGRES_PORT=5432

sudo docker run --name pgosm -d --rm \
    -v ~/pgosm-data:/app/output \
    -v /etc/localtime:/etc/localtime:ro \
    -e POSTGRES_USER=$POSTGRES_USER \
    -e POSTGRES_PASSWORD=$POSTGRES_PASSWORD \
    -e POSTGRES_HOST=$POSTGRES_HOST \
    -e POSTGRES_DB=$POSTGRES_DB \
    -e POSTGRES_PORT=$POSTGRES_PORT \
    -p 5433:5432 -d rustprooflabs/pgosm-flex

sudo docker run --name pgosm -d --rm \
    -v ~/pgosm-data:/app/output \
    -v /etc/localtime:/etc/localtime:ro \
    -p 5433:5432 -d rustprooflabs/pgosm-flex

However it appears to still be using the internal docker database.

Output so far..

ubuntu@openstreet:~/pgosm-data$ sudo docker exec -it pgosm python3 docker/pgosm_flex.py     --ram=14     --input-file=us-latest.osm.pbf     --skip-dump
2022-11-24 00:45:18,681:INFO:pgosm-flex:pgosm_flex:PgOSM Flex starting...
2022-11-24 00:45:18,681:INFO:pgosm-flex:db:Checking for Postgres service to be available
2022-11-24 00:45:24,702:INFO:pgosm-flex:db:Postgres instance ready
2022-11-24 00:45:24,759:INFO:pgosm-flex:db:Removed pgosm database
2022-11-24 00:45:24,817:INFO:pgosm-flex:db:Created pgosm database
2022-11-24 00:45:25,299:INFO:pgosm-flex:db:Loading extras via Sqitch plus QGIS styles.
2022-11-24 00:45:25,299:INFO:pgosm-flex:db:Deploy schema via Sqitch
2022-11-24 00:45:26,002:INFO:pgosm-flex:db:Loading US Roads helper data
2022-11-24 00:45:26,043:INFO:pgosm-flex:db:Sqitch deployment complete
2022-11-24 00:45:26,044:INFO:pgosm-flex:db:Load QGIS styles...
2022-11-24 00:45:26,121:INFO:pgosm-flex:db:QGIS Style table populated
2022-11-24 00:45:26,126:INFO:pgosm-flex:pgosm_flex:Running normal osm2pgsql mode
2022-11-24 00:45:26,127:INFO:pgosm-flex:pgosm_flex:Running osm2pgsql
dangelsaurus commented 2 years ago

after taking a closer look at https://github.com/rustprooflabs/pgosm-flex/releases/tag/0.4.3, I see Default is localhost for in-Docker operation I will try again with a true external host name