Changes between Version 32 and Version 33 of DevWikiDockerTesting

Timestamp:

01/30/23 20:20:33 (22 months ago)

Author:

robe

Comment:

--

DevWikiDockerTesting

@@ -98 +98 @@
 
 {{{
+cd ~/
+mkdir projects
 docker pull postgis/postgis:latest
 docker run --name postgis-test -e POSTGRES_PASSWORD=mysecretpassword -d postgis/postgis
+# the -v command is to persist the data in the ~/postgres-data 
+# (folder in your home folder, on start the folder will be created and owned by the postgres user in docker container). 
+# If you don't care about the data you can leave that out and all data will be lost when container shuts down.
+
 docker run -d \
   --name postgis-test \
   -e POSTGRES_PASSWORD=whatever \
   -p 5432:5432 \
-  -v /projects/postgis-data:/var/lib/postgresql/data \
+  -v ~/postgres-data:/var/lib/postgresql/data \
   -d postgis/postgis
 
 #If you have psql client or pgAdmin, you can connect to via local port
-psql -h localhost -p 5432
+psql -h localhost -p 5432 -U postgres
+
+# once in psql, you can do following
+
+create database gisdb;
+\c gisdb
+CREATE EXTENSION postgis;
+SELECT postgis_full_version();
 
 # alternatively use the psql inside it