Skip to content

Instantly share code, notes, and snippets.

View Skatox's full-sized avatar
🏠
Working from home

Miguel Useche Skatox

🏠
Working from home
View GitHub Profile
@Skatox
Skatox / upgrade.sh
Last active March 31, 2018 20:43 — forked from uggedal/upgrade.sh
Upgrade postgresql from 9.4 to 9.5 on Arch Linux
systemctl stop postgresql && pacman -Syu --noconfirm && su - postgres -c 'mv /var/lib/postgres/data /var/lib/postgres/olddata' && su - postgres -c "initdb --locale en_US.UTF-8 -D '/var/lib/postgres/data'" && systemctl start postgresql.service && systemctl stop postgresql.service && pacman -S postgresql-old-upgrade --noconfirm && su - postgres -c 'pg_upgrade -d /var/lib/postgres/olddata/ -D /var/lib/postgres/data/ -b /opt/pgsql-9.4/bin/ -B /usr/bin/' && /var/lib/postgres/delete_old_cluster.sh && rm /var/lib/postgres/delete_old_cluster.sh && /var/lib/postgres/analyze_new_cluster.sh && systemctl start postgresql.service && pacman -Rs postgresql-old-upgrade --noconfirm