Upgrade postgresql-8.4 to postgresql-9.1 on debian

| Posted: - Last updated:
| Tagged ubuntu debian dba postgres postgresql
| ~200wrds (~1min)

Today I upgraded a production PostgreSQL 8.4 database to version 9.1. This was on a Debian server. ~ The first step is to make a full dump of your data. I personally like to store that dump somewhere safe before upgrading. As root:

su - postgres
pg_dumpall > dump.sql
cp ~postgres/dump.sql /root/

Now you can safely remove the postgresql-8.4 and install postgresql-9.1:

aptitude purge postgresql-8.4
aptitude install postgresql-9.1

Next check the postgresql configuration in /etc/postgresql/9.1/main. If you make any changes, make sure to restart postgres with /etc/init.d/postgresql restart.

Postgresql 9.1 is now up and running, let’s import our data back into it.

su - postgres
psql < dump.sql

That’s all. You’re now fully upgraded to PostgreSQL 9.1.

My site is free of ads and trackers. I record privacy-respecting usage statistics with Fathom.

Was this post helpful to you? Why not ☕ Buy me a coffee or use Brave Browser to send a tip.