Hi All,
In case it will help someone here is what I did to upgrade from PostgreSQL
v8.0.0 to PosgreSQL v8.0.2. For me the real driver behind this upgrade was to
add plperl during the compile. I didn't HAVE to upgrade but since I had to
compile anyway it seemed like an intelligent thing to do.
Kind Regards,
Keith
Download PostgreSQL v8.0.2
postgresql-8.0.2.tar.gz
postgresql-8.0.2.tar.gz.md5
Verify the download
# md5sum postgresql-8.0.0rc5.tar.gz
# more postgresql-8.0.0rc5.tar.gz.md5
Stop the postmaster
# service rhdb status
postmaster (pid 1865 1864 1862) is running...
# service rhdb stop
Stopping PostgreSQL - Red Hat Edition service: [ OK ]
# service rhdb status
postmaster is stopped
Copy the startup scripts to a safe location
# cd /downloads
# cp -p /etc/sysconfig/pgsql/rhdb etc_sysconfig_pgsql_rhdb
# cp -p /etc/init.d/rhdb etc_init.d_rhdb
Copy the configuration files to a safe location
# cd /downloads
# cp -p /databases/pg_hba.conf databases_pg_hba.conf
# cp -p /databases/pg_ident.conf databases_pg_ident.conf
# cp -p /databases/postgresql.conf databases_postgresql.conf
Copy the current database directory out of the way
# cp -rp databases databases-8.0.0
Move the current installation directory out of the way
# mv pgsql/ pgsql-8.0.0
Unpack the files
# gzip -dc postgresql-8.0.2.tar.gz | tar -xvf -
Configure the installation
# cd postgresql-8.0.2
# ./configure -with-perl
Build the installation
# gmake
Regression test
# su postgres
postgres$ gmake check
postgres$ exit
Install the software
# gmake install
Clean up the build directory
# gmake clean
Set up shared libraries
# ldconfig /usr/local/pgsql/lib
Start the postmaster
# service rhdb status
postmaster is stopped
# service rhdb start
Starting PostgreSQL - Red Hat Edition service: [ OK ]
# service rhdb status
postmaster (pid 6553 6552 6551 6547) is running...
