Date: Thu, 8 Aug 2019 12:50:40 +0200 From: Matthias Fechner <idefix@fechner.net> To: Torsten Zuehlsdorff <freebsd@toco-domains.de>, Palle Girgensohn <girgen@FreeBSD.org>, ports-committers@freebsd.org, svn-ports-all@freebsd.org, svn-ports-head@freebsd.org, Sunpoet Po-Chuan Hsieh <sunpoet@FreeBSD.org> Subject: Re: svn commit: r505245 - in head/databases: postgresql10-client postgresql10-contrib postgresql10-pgtcl postgresql10-server postgresql11-client postgresql11-server postgresql94-server postgresql95-cli... Message-ID: <18a4b88d-ce9d-88a8-2fb5-1d9bd8036f0d@fechner.net> In-Reply-To: <9ac8aad8-3635-01eb-6033-c4a337f03139@fechner.net> References: <201906272128.x5RLS0Uv072609@repo.freebsd.org> <e0f21a7b-c748-b55a-d228-bae0f11fdfd2@fechner.net> <899f2367-828a-9eca-dfaa-e34a039fcdac@toco-domains.de> <9ac8aad8-3635-01eb-6033-c4a337f03139@fechner.net>
next in thread | previous in thread | raw e-mail | index | archive | help
Am 28.07.2019 um 10:16 schrieb Matthias Fechner: > - Upgrade PostgreSQL to at least 10.7: > https://docs.gitlab.com/omnibus/settings/database.html#upgrade-packaged-postgresql-server > > Maybe we can coordinate the upgrade of PostgreSQL to 11, with rails to > 5.2 with Gitlab to 12.1? I did now a successfull update (with the old Gitlab version) to PostgreSQL 11 (on a test environment) with: service gitlab stop service postgresql stop pkg create postgresql96-server postgresql96-contrib mkdir /tmp/pg-upgrade tar xf postgresql96-server-9.6.14_1.txz -C /tmp/pg-upgrade tar xf postgresql96-contrib-9.6.14_1.txz -C /tmp/pg-upgrade pkg delete -f postgresql96-server postgresql96-contrib postgresql96-client pkg install postgresql11-server postgresql11-contrib postgresql11-client pkg upg /usr/local/etc/rc.d/postgresql initdb su -l postgres -c "pg_upgrade -b /tmp/pg-upgrade/usr/local/bin/ -d /var/db/postgres/data96/ -B /usr/local/bin/ -D /var/db/postgres/data11/" service postgresql start service gitlab start #Verify everything works su -l postgres -c "cd /var/db/postgres && /usr/local/bin/vacuumdb --all --analyze-in-stages" su -l postgres -c "cd /var/db/postgres && rm -rf '/var/db/postgres/data96'" rm /var/db/postgres/analyze_new_cluster.sh rm /var/db/postgres/delete_old_cluster.sh rm -R /tmp/pg-upgrade You maybe have to adapt the version from 96 to 95 if you use the current standard version from ports. Maybe this helps some to do further tests with the PostgreSQL version 11. Gruß Matthias -- "Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning." -- Rich Cook
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?18a4b88d-ce9d-88a8-2fb5-1d9bd8036f0d>