X-Git-Url: https://vcs.fsf.org/?a=blobdiff_plain;f=templates%2Fpostgres.template.yml;h=abed0f4e98d0e2e3c7f65e0f79168158734f5fba;hb=6d00b2fab0a046bf08e2c3148b2b3bab8fc5cdcf;hp=40f41a26e9a2d4a503de289d40d96dd4412e5970;hpb=80c11be3440eb5df114d6ac6912561e19c239738;p=discourse_docker.git diff --git a/templates/postgres.template.yml b/templates/postgres.template.yml index 40f41a2..abed0f4 100644 --- a/templates/postgres.template.yml +++ b/templates/postgres.template.yml @@ -19,38 +19,102 @@ hooks: 0 */4 * * * /var/lib/postgresql/take-database-backup before_code: - - replace: - filename: /etc/service/sidekiq/run - from: "# postgres" - to: sv start postgres || exit 1 - replace: filename: /etc/service/unicorn/run from: "# postgres" to: sv start postgres || exit 1 run: + # temporary + - exec: apt-get install -y socat + - exec: mkdir -p /shared/postgres_run + - exec: chown postgres:postgres /shared/postgres_run + - exec: chmod 775 /shared/postgres_run + - exec: rm -fr /var/run/postgresql + - exec: ln -s /shared/postgres_run /var/run/postgresql + - exec: socat /dev/null UNIX-CONNECT:/shared/postgres_run/.s.PGSQL.5432 || exit 0 && echo postgres already running stop container ; exit 1 + - exec: rm -fr /shared/postgres_run/.s* + - exec: rm -fr /shared/postgres_run/*.pid - file: path: /etc/service/postgres/run chmod: "+x" contents: | #!/bin/sh exec 2>&1 - exec sudo -u postgres /usr/lib/postgresql/9.2/bin/postmaster -D /etc/postgresql/9.2/main - + exec sudo -u postgres /usr/lib/postgresql/9.3/bin/postmaster -D /etc/postgresql/9.3/main + - file: + path: /root/upgrade_postgres + chmod: "+x" + contents: | + #!/bin/bash + if [ "9.2" = `cat /shared/postgres_data/PG_VERSION` ]; then + echo Upgrading PostgreSQL to from version 9.2 to 9.3 + rm -fr /shared/postgres_data_new + install -d -m 0755 -o postgres -g postgres /shared/postgres_data_new && sudo -u postgres /usr/lib/postgresql/9.3/bin/initdb -D /shared/postgres_data_new || exit 0 + apt-get update + apt-get install -y postgresql-9.2 + /etc/init.d/postgresql stop + rm -fr /shared/postgres_data/postmaster.pid + cd ~postgres + cp /etc/postgresql/9.2/main/*.conf /shared/postgres_data + echo >> /shared/postgres_data/postgresql.conf + echo "data_directory = '/shared/postgres_data'" >> /shared/postgres_data/postgresql.conf + SUCCESS=true + sudo -u postgres /usr/lib/postgresql/9.3/bin/pg_upgrade -d /shared/postgres_data -D /shared/postgres_data_new -b /usr/lib/postgresql/9.2/bin -B /usr/lib/postgresql/9.3/bin || SUCCESS=false + + if [[ "$SUCCESS" == 'false' ]]; then + echo ------------------------------------------------------------------------------------- + echo UPGRADE OF POSTGRES FAILED + echo + echo You are going to need to export your data and import into a clean instance: + echo + echo Add the line: 'base_image: "samsaffron/discourse:0.1.1"' + echo Change: "templates/postgres.template.yml TO templates/postgres.9.2.template.yml" + echo + echo Run "./launcher bootstrap" again + echo + echo When your instance is running: + echo - Go to the admin UI, enable readonly and backup your site + echo + echo Then destroy your container "./launcher destroy standalone" + echo Undo the base_image and postgres.9.2 template from your container config + echo Run: "sudo mv /var/docker/shared/postgres_data /var/shared/postgres_data_old" + echo Run: "./launcher bootstrap" + echo + echo "Login to the blank site, and import your backup (remember to set the allow_restore site setting)" + echo Restart your container: "./launcher restart" + echo ------------------------------------------------------------------------------------- + exit 1 + fi + + mv /shared/postgres_data /shared/postgres_data_old + mv /shared/postgres_data_new /shared/postgres_data + + echo ------------------------------------------------------------------------------------- + echo UPGRADE OF POSTGRES COMPLETE + echo + echo Old 9.2 database is stored at /shared/postgres_data_old + echo + echo Please run "./launcher bootstrap" again + echo ------------------------------------------------------------------------------------- + exit 1 + fi - exec: cmd: - - chown -R root /var/lib/postgresql/9.2/main - - "[ ! -e /shared/postgres_data ] && install -d -m 0755 -o postgres -g postgres /shared/postgres_data && sudo -u postgres /usr/lib/postgresql/9.2/bin/initdb -D /shared/postgres_data || exit 0" + - chown -R root /var/lib/postgresql/9.3/main + - "[ ! -e /shared/postgres_data ] && install -d -m 0755 -o postgres -g postgres /shared/postgres_data && sudo -E -u postgres /usr/lib/postgresql/9.3/bin/initdb -D /shared/postgres_data || exit 0" - chown -R postgres:postgres /shared/postgres_data + - chown -R postgres:postgres /var/run/postgresql + - exec: /root/upgrade_postgres - replace: - filename: "/etc/postgresql/9.2/main/postgresql.conf" - from: "data_directory = '/var/lib/postgresql/9.2/main'" + filename: "/etc/postgresql/9.3/main/postgresql.conf" + from: "data_directory = '/var/lib/postgresql/9.3/main'" to: "data_directory = '/shared/postgres_data'" # listen on all interfaces - replace: - filename: "/etc/postgresql/9.2/main/postgresql.conf" + filename: "/etc/postgresql/9.3/main/postgresql.conf" from: /#?listen_addresses *=.*/ to: "listen_addresses = '*'" @@ -60,29 +124,29 @@ run: - install -d -m 0755 -o postgres -g postgres /shared/postgres_backup - replace: - filename: "/etc/postgresql/9.2/main/postgresql.conf" + filename: "/etc/postgresql/9.3/main/postgresql.conf" from: /#?max_wal_senders *=.*/ to: "max_wal_senders = 4" - replace: - filename: "/etc/postgresql/9.2/main/postgresql.conf" + filename: "/etc/postgresql/9.3/main/postgresql.conf" from: /#?wal_level *=.*/ to: "wal_level = hot_standby" - replace: - filename: "/etc/postgresql/9.2/main/pg_hba.conf" + filename: "/etc/postgresql/9.3/main/pg_hba.conf" from: /^#local +replication +postgres +peer$/ to: "local replication postgres peer" # allow all to connect in with md5 auth - replace: - filename: "/etc/postgresql/9.2/main/pg_hba.conf" + filename: "/etc/postgresql/9.3/main/pg_hba.conf" from: /^host.*all.*all.*127.*$/ to: "host all all 0.0.0.0/0 md5" - exec: background: true - cmd: "sudo -u postgres /usr/lib/postgresql/9.2/bin/postmaster -D /etc/postgresql/9.2/main" + cmd: "sudo -u postgres /usr/lib/postgresql/9.3/bin/postmaster -D /etc/postgresql/9.3/main" # give db a few secs to start up - exec: "sleep 5" @@ -100,6 +164,7 @@ run: cmd: sudo -u postgres psql discourse raise_on_fail: false + - exec: /bin/bash -c 'sudo -u postgres psql discourse <<< "alter schema public owner to discourse;"' - exec: /bin/bash -c 'sudo -u postgres psql discourse <<< "create extension if not exists hstore;"' - exec: /bin/bash -c 'sudo -u postgres psql discourse <<< "create extension if not exists pg_trgm;"'