Skip to content

Instantly share code, notes, and snippets.

@wbond

wbond/postgresql_upgrade.sh

Created September 21, 2012 06:18
Show Gist options
  • Save wbond/3759992 to your computer and use it in GitHub Desktop.
Save wbond/3759992 to your computer and use it in GitHub Desktop.
Download ZIP
Upgrade from PostgreSQL 9.1 to 9.2
Raw
postgresql_upgrade.sh
apachectl stop
/root/src/postgresql-9.2.0/src/bin/pg_dump/pg_dumpall > /root/pgsql.backup
/etc/init.d/postgresql stop
mv /usr/local/pgsql /usr/local/pgsql.bak
cd /root/src/postgresql-9.2.0
make install
su postgres
/usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
exit
/etc/init.d/postgresql start
/usr/local/pgsql/bin/psql -d postgres -f /root/pgsql.backup
apachectl start
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment