Ubuntu
postgresql-8.3 package

  1. Bug #403381
  2. Comment #13

Comment 13 for bug 403381

Revision history for this message
elatllat (elatllat) wrote :

On the missing 8.3 install instructions:
(untested for now)

DUMP=/my/dump/path
MYDB=preciousdata
pg_ctlcluster 8.4 main stop
pg_dropcluster 8.4 main
echo -e "\ndeb http://security.ubuntu.com/ubuntu hardy-security main restricted\ndeb-src http://security.ubuntu.com/ubuntu hardy-security main restricted\n">>/etc/apt/sources.list
apt-get update
apt-get install -y postgresql-8.3
#not needed
    #pg_ctlcluster 8.3 main start
# extra backup
    cp -r /var/lib/postgresql/8.3/main $DUMP/copy
    su postgres -c "pg_dumpall -f $DUMP/$MYDB.dump -l $MYDB -U postgres"
pg_upgradecluster -v 8.4 8.3 main
pg_ctlcluster 8.3 main stop
pg_dropcluster 8.3 main
pg_ctlcluster 8.4 main start
apt-get remove -y postgresql-8.3

Thanks to Flannel on irc://chat.freenode.net/#ubuntu