[Bug 239514] [exp-run] databases/postgresql: Make PostreSQL 11 new default

[bugzilla-noreply at freebsd.org]

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=239514

Matthias Fechner <mfechner at FreeBSD.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Depends on|239652                      |

--- Comment #10 from Matthias Fechner <mfechner at FreeBSD.org> ---
Just for reference, the upgrade instruction could be:
service gitlab stop
service postgresql stop
pkg create postgresql95-server postgresql95-contrib
mkdir /tmp/pg-upgrade
tar xf postgresql96-server-9.5.18_1.txz -C /tmp/pg-upgrade
tar xf postgresql96-contrib-9.5.18_1.txz -C /tmp/pg-upgrade

pkg delete -f postgresql95-server postgresql95-contrib postgresql95-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/data95/ -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/data95'"
rm /var/db/postgres/analyze_new_cluster.sh
rm /var/db/postgres/delete_old_cluster.sh

rm -R /tmp/pg-upgrade


Referenced Bugs:

https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=239652
[Bug 239652] databases/skytools: Unbreak build with PostgreSQL 11
-- 
You are receiving this mail because:
You are on the CC list for the bug.