diff --git a/README.md b/README.md index 089b3fe..48667b6 100644 --- a/README.md +++ b/README.md @@ -9,15 +9,15 @@ "PostGIS"を起動する * Use by DockerHub `kartoza/postgis:9.6-2.4` - + 1) `docker pull kartoza/postgis:9.6-2.4` - + 2) `WORKAREA=$pwd` - + 3) `mkdir $HOME/pg_data` - + 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` * `-m 2g` momory 2GB * `-e POSTGRES_USER=gisuser` @@ -27,7 +27,7 @@ * `-p 5432:5432` * `-v $HOME/pg_data:/var/lib/postgresql` PostgreSQL databade data folder * `--restart=always` - + ``` $ docker pull kartoza/postgis:9.6-2.4 $ mkdir @@ -36,3 +36,53 @@ $ ``` + +## "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" + +3) pgAdmin4 : Login + + * `http://localhost/` + * userid: `gisuser@domain.com` + * password: `gisuser` + +4) pgAdmin4 : 接続 / Connection + + * host name: `localhost` + * port: `5432` + * database admin: `postgres` + * user name: `alex` + * password: `password` + + +## "PostGISへの接続設定ファイル"を準備する + +* postgis `osmdb.properties` + +``` +db_driver=org.postgresql.Driver +db_url=jdbc:postgresql://172.17.0.1:5432/osmdb +db_user=alex +db_passwd=password +``` + +"" + +6. osm2pgsql + +``` +echo '*:*:*:alex:password' > ~/.pgpass +chmod 600 ~/.pgpass +``` + +91. stop pgAdmin4 `docker stop stupefied_poitras` + +92. stop postGIS `docker stop postgis` + diff --git a/start.sh b/start.sh index f297953..28781d8 100755 --- a/start.sh +++ b/start.sh @@ -1,7 +1,6 @@ docker pull kartoza/postgis:9.6-2.4 mkdir -p pg_data -docker run -d \ --m 2g \ +docker run -d -m 2g \ -e POSTGRES_USER=gisuser \ -e POSTGRES_PASS=password \ -e POSTGRES_DBNAME=gisdb \