I succeeded in installing Postgresql 7.4.2 pretty much as I had planned
it below. I found that I had to edit the old startup script for the new
version and add the path to the man.conf file for the new man pages.
Previously I had used a utility called pgaccess for some things. I
pulled the latest version of pgaccess that I could find but it does not
work with the latest database.
The latest version appears to have caused problems with the database. I
restored my backup and everything is working again.
Does anyone know if pgaccess is still maintained? The web site
http://www.pgaccess.org does not appear to exist anymore.
Are there other similar utilities available and currently maintained?
And thanks to all those that responded with suggestions and pointers
regarding the upgrade process from 7.2.4 to 7.4.2.
On Fri, 2004-06-11 at 13:20, Scot L. Harris wrote:
> I have been using Postgresql 7.2.4 on a Redhat 8.0 system. Prior to
> putting the system into production I want to upgrade Postgresql and PHP
> to the latest stable versions.
>
> To that end I have downloaded the latest versions and compiled them. I
> have saved my current databases using pg_dumpall.
>
> Currently I have the last versions that Redhat provided for Postgresql
> which is version 7.2.4.
>
> I believe what I need to do now is shutdown the current database, remove
> the RPMs installed for 7.2.4 and run the make install for 7.4.2,
> rebuild/reload the databases.
>
> Prior to doing that are there any steps that I am missing?
>
> I will be removing the following packages from the system:
>
> postgresql-server-7.2.4-5.80
> postgresql-docs-7.2.4-5.80
> postgresql-libs-7.2.4-5.80
> postgresql-tcl-7.2.4-5.80
> postgresql-7.2.4-5.80
> postgresql-tk-7.2.4-5.80
> postgresql-odbc-7.2.4-5.80
> postgresql-devel-7.2.4-5.80
> postgresql-perl-7.2.4-5.80
>
> I built the 7.4.2 version with tcl, perl, and tk support so I am
> assuming that takes care of the packages listed above.
>
> Thanks in advance for your suggestions and recommendations.
--
Scot L. Harris
webid@cfl.rr.com
Be cheerful while you are alive.
-- Phathotep, 24th Century B.C.
