Date: Thu, 8 Aug 2019 20:14:23 +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: <c18736d5-44ba-48de-8682-c7b6affe584d@fechner.net> In-Reply-To: <18a4b88d-ce9d-88a8-2fb5-1d9bd8036f0d@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> <18a4b88d-ce9d-88a8-2fb5-1d9bd8036f0d@fechner.net>
next in thread | previous in thread | raw e-mail | index | archive | help
Am 08.08.2019 um 12:50 schrieb Matthias Fechner: > 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. I upgraded now all my production databases with these steps from version 9.6 -> 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?c18736d5-44ba-48de-8682-c7b6affe584d>