Changes between Version 27 and Version 28 of DevWikiDockerTesting
- Timestamp:
- Jan 30, 2023, 1:21:51 PM (19 months ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
DevWikiDockerTesting
v27 v28 52 52 export PATH=/usr/lib/postgresql/$PGVER/bin:$PATH 53 53 #do this to be able to access from host 54 psql - Upostgres -c "ALTER SYSTEM SET listen_addresses='*';"54 psql -d postgres -c "ALTER SYSTEM SET listen_addresses='*';" 55 55 # change whatever to something more secure, if you care 56 psql - Upostgres -p 5436 -c "ALTER ROLE postgres PASSWORD 'whatever';"56 psql -d postgres -p 5436 -c "ALTER ROLE postgres PASSWORD 'whatever';" 57 57 echo "host all all 0.0.0.0/0 scram-sha-256" >> /etc/postgresql/${PGVER}/main/pg_hba.conf 58 58 #shows you list of associate ports for each postgres version (connecting from your host machine would be 6 instead of 5) … … 79 79 80 80 docker rm postgis-dev 81 82 }}} 83 84 === Connecting to PostgreSQL from your host machine === 85 {{{ 86 psql -U postgres -h localhost -p 6436 #this is the one running PG15 at time of writing 81 87 82 88 }}}