Changes between Version 27 and Version 28 of DevWikiDockerTesting

Timestamp:

Jan 30, 2023, 1:21:51 PM (19 months ago)

Author:

robe

Comment:

—

DevWikiDockerTesting

@@ -52 +52 @@
 export PATH=/usr/lib/postgresql/$PGVER/bin:$PATH
 #do this to be able to access from host
-psql -U postgres -c "ALTER SYSTEM SET listen_addresses='*';"
+psql -d postgres -c "ALTER SYSTEM SET listen_addresses='*';"
 # change whatever to something more secure, if you care
-psql -U postgres -p 5436 -c "ALTER ROLE postgres PASSWORD 'whatever';"
+psql -d postgres -p 5436 -c "ALTER ROLE postgres PASSWORD 'whatever';"
 echo "host  all all 0.0.0.0/0 scram-sha-256" >> /etc/postgresql/${PGVER}/main/pg_hba.conf
 #shows you list of associate ports for each postgres version (connecting from your host machine would be 6 instead of 5)
@@ -79 +79 @@
 
 docker rm postgis-dev
+
+}}}
+
+=== Connecting to PostgreSQL from your host machine ===
+{{{
+psql -U postgres -h localhost -p 6436  #this is the one running PG15 at time of writing
 
 }}}