Upgrade PosgreSQL 8.1 ke 8.3 di Lenny
Assalamu'alaikum Wr.Wb Melakukan Upgrade Postgresql 8.1 ke 8.3 di debian Lenny dapat dilakukan dengan cara sebagai berikut backup semua database ( $pg_dumpall > all.dbs.out ) Install postgresql-8.3 ( $ apt-get install postgresql-8.3 ) Sebagai root : matikan cluster postgresql 8.3 ( # pg_dropcluster --stop 8.3 main ) lakukan upgrade cluster 8.1 ( # pg_upgradecluster 8.1 main ) pada langkah di atas akan muncul tampilan seperti berikut # pg_upgradecluster 8.1 main Creating new cluster (configuration: /etc/postgresql/8.3/main, data: /var/lib/postgresql/8.3/main)... Moving configuration file /var/lib/postgresql/8.3/main/postgresql.conf to /etc/postgresql/8.3/main... Moving configuration file /var/lib/postgresql/8.3/main/pg_hba.conf to /etc/postgresql/8.3/main... Moving configuration file /var/lib/postgresql/8.3/main/pg_ident.conf to /etc/postgresql/8.3/main... Configuring postgresql.conf to use port 5433... Disabling connections to the old cluster during