Changes between Version 27 and Version 28 of DevWikiDockerTesting


Ignore:
Timestamp:
01/30/23 13:21:51 (22 months ago)
Author:
robe
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • DevWikiDockerTesting

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