Re: migration postgresql

[Michelle Konzack <linux4michelle@freenet.de>]

Am 2006-02-25 16:29:27, schrieb Tom Allison:
> Any lessons for migration from 7.4 to 8.1?
> 
------------------------- END OF REPLYED MESSAGE -------------------------

1)  make pgdump_all to a differen partiton
2)  stop your pstgresql entirely
3)  flush the DiskCache manauly
4)  tar the whole /usr/lib/postgresql directory and store
    the tarball on a secure partition or pother place
5)  use dpkg-repack to make a debian package of the installed
    pstgresql version for security. (plus all depending pgsql packages)
6)  Save the configs from /etc/postgresql on a secure place

7)  upgrade to postgresq l8.1

Now while upgrading postgresql should make correctly pgdum_all

8)  configure it
9)  start it

If all is working fine:     Congratulation

If not, 'apt-get --purge remove postgresql' and the install the
repacked version of it and then unpack the postgresql tarball

Greetings
    Michelle Konzack
    Systemadministrator
    Tamay Dogan Network
    Debian GNU/Linux Consultant


-- 
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack   Apt. 917                  ICQ #328449886
                   50, rue de Soultz         MSM LinuxMichi
0033/3/88452356    67100 Strasbourg/France   IRC #Debian (irc.icq.com)