diff --git a/doc/osmCoverage.md b/doc/osmCoverage.md index 591cc36..425d8ca 100644 --- a/doc/osmCoverage.md +++ b/doc/osmCoverage.md @@ -46,11 +46,12 @@ 2) `WORKAREA=$pwd` -2) `mkdir $HOME/pg_data` +3) `mkdir $HOME/pg_data` -3) `docker run --name=osmdb -d -e POSTGRES_USER=alex -e POSTGRES_PASS=password -e POSTGRES_DBNAME=osmdb -e ALLOW_IP_RANGE=0.0.0.0/0 -p 5432:5432 -v $HOME/pg_data:/var/lib/postgresql --restart=always kartoza/postgis:9.6-2.4` +4) `docker run --name=osmdb -m 2g -d -e POSTGRES_USER=alex -e POSTGRES_PASS=password -e POSTGRES_DBNAME=osmdb -e ALLOW_IP_RANGE=0.0.0.0/0 -p 5432:5432 -v $HOME/pg_data:/var/lib/postgresql --restart=always kartoza/postgis:9.6-2.4` - * --name=osmdb + * `--name=osmdb` + * `-m 2g` momory 2GB * `-e POSTGRES_USER=alex` * `-e POSTGRES_PASS=password` * `-e POSTGRES_DBNAME=osmdb` @@ -60,32 +61,33 @@ * `--restart=always` ``` - $ docker pull kartoza/postgis:9.6-2.4 $ mkdir $ mkdir $HOME/pg_data -$ docker run --name=osmdb -d -e POSTGRES_USER=alex -e POSTGRES_PASS=password -e POSTGRES_DBNAME=osmdb -e ALLOW_IP_RANGE=0.0.0.0/0 -p 5432:5432 -v $HOME/pg_data:/var/lib/postgresql --restart=always kartoza/postgis:9.6-2.4 +$ docker run -m 2g --name=osmdb -d -e POSTGRES_USER=alex -e POSTGRES_PASS=password -e POSTGRES_DBNAME=osmdb -e ALLOW_IP_RANGE=0.0.0.0/0 -p 5432:5432 -v $HOME/pg_data:/var/lib/postgresql --restart=always kartoza/postgis:9.6-2.4 $ ``` "pgAdmin4"で接続を確認する -1) `docker run --name=pgadmin4 -p 80:80 -e "PGADMIN_DEFAULT_EMAIL=gisuser@domain.com" -e "PGADMIN_DEFAULT_PASSWORD=gisuser" -d dpage/pgadmin4` +1) `docker pull dpage/pgadmin4` + +2) `docker run --name=pgadmin4 -p 80:80 -e "PGADMIN_DEFAULT_EMAIL=gisuser@domain.com" -e "PGADMIN_DEFAULT_PASSWORD=gisuser" -d dpage/pgadmin4` * --name=pgadmin4 * -e "PGADMIN_DEFAULT_EMAIL=gisuser@domain.com" * -e "PGADMIN_DEFAULT_PASSWORD=gisuser" -2) pgAdmin4 : Login +3) pgAdmin4 : Login * `http://localhost/` * userid: `gisuser@domain.com` * password: `gisuser` -3) pgAdmin4 : 接続 / Connection +4) pgAdmin4 : 接続 / Connection - * host name: `localhost` + * host name: `172.17.0.1` * port: `5432` * database admin: `postgres` * user name: `alex` @@ -98,7 +100,7 @@ ``` db_driver=org.postgresql.Driver -db_url=jdbc:postgresql://localhost:5432/gis +db_url=jdbc:postgresql://172.17.0.1:5432/osmdb db_user=alex db_passwd=password ```