hetzner/db/postgis/LOEMIND.txt

# Päringud konteinerist
# Postgis'i õiguste ja konfi faili asukoht
docker exec  $(docker ps -q -f name=postgis_primary) psql -U postgres -c "SELECT * FROM pg_hba_file_rules;"
docker exec  $(docker ps -q -f name=postgis_primary) psql -U postgres -c "SHOW hba_file;"



## --------------------------------------------------------------
# https://info.crunchydata.com/blog/easy-postgresql-cluster-recipe-using-docker-1.12
# https://github.com/CrunchyData/crunchy-containers/blob/master/examples/docker/swarm-service/docker-compose.yml
docker service ps master
docker service ps replica
# Given the PostgreSQL replica service is named replica, you can scale up the number of replica containers by running this command:
docker service scale replica=2
docker service ls



mkdir -p .secrets
openssl rand -base64 32 > .secrets/postgis_primary_user_password
openssl rand -base64 32 > .secrets/postgis_user_password
openssl rand -base64 32 > .secrets/postgis_root_password
docker stack deploy -c postgis.yml postgis
docker service ls