Docker base image with PostgreSQL 10 released

tgxworld · 23 april 2018 om 23:50

I wanted to see the user’s disk space usage and -h makes it easier to read for me. The source code always has the answer

github.com

discourse/discourse_docker/blob/56032fc353419695f0ddae20884f83da61dccf88/templates/postgres.template.yml#L64


      
          
          - file:
             path: /root/upgrade_postgres
             chmod: "+x"
             contents: |
               #!/bin/bash
               PG_MAJOR_OLD=`cat /shared/postgres_data/PG_VERSION`
          
               if [ ! "10" = "$PG_MAJOR_OLD" ]; then
                 echo Upgrading PostgreSQL from version ${PG_MAJOR_OLD} to 10
                 free_disk=$(df /var | tail -n 1 | awk '{print $4}')
                 required=$(($(du -s /shared/postgres_data | awk '{print $1}') * 2))
          
                 if [ "$free_disk" -lt "$required" ]; then
                  echo "WARNING: Upgrading PostgresSQL would require an addtional $(numfmt --to=si $(($required - $free_disk))) of disk space"
                  echo "Please free up some space, or expand your disk, before continuing."
                  echo ''
                  echo 'To avoid upgrading change "templates/postgres.template.yml" TO "templates/postgres.9.5.template.yml" in containers/app.yml'
                  exit 1
                 fi

Topic		Antwoorden	Weergaven
Forum crashes after upgrading from 2.4.0 Installation	10	1064	3 augustus 2020
Stuck in a loop of freeing up space and filling it up again when rebuilding Installation server-resources	33	3742	8 juni 2024
Upgrade failed spectacularily Support	25	464	10 februari 2025
PostgreSQL 15 update Announcements	104	3509	9 juni 2025
Failing update Installation	34	227	26 augustus 2025

Docker base image with PostgreSQL 10 released

Gerelateerde topics