Skip to content

Instantly share code, notes, and snippets.

@vivus-ignis

vivus-ignis/upgrade_postgresql.sh

Last active August 29, 2015 14:04
Show Gist options
  • Save vivus-ignis/aa1fcde4f45bdfa39429 to your computer and use it in GitHub Desktop.
Save vivus-ignis/aa1fcde4f45bdfa39429 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
upgrade_postgresql.sh
# upgrade postgresql on debian
set -e
echo 'deb http://apt.postgresql.org/pub/repos/apt/ wheezy-pgdg main' >> /etc/apt/sources.list.d/pgpd.list
wget https://www.postgresql.org/media/keys/ACCC4CF8.asc
apt-key add ACCC4CF8.asc
apt-get update
apt-get install -y postgresql-9.3
pg_dropcluster 9.3 main --stop
export LC_ALL=$LANG
export LC_CTYPE=$LANG
pg_upgradecluster 9.1 main # --> downtime here
pg_dropcluster 9.1 main
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment