Skip site navigation (1) Skip section navigation (2)

Upgrading from PostgreSQL 7.4.3

From: peter(at)vfemail(dot)net
To: pgsql-novice(at)postgresql(dot)org
Subject: Upgrading from PostgreSQL 7.4.3
Date: 2010-04-14 15:58:42
Message-ID: 20100414155936.088D8632509@mail.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-novice
I'm running PostgreSQL version 7.4.3 on a Dell PowerEdge SC400 running FreeBSD 4.10.  Fresh SCSI drives were installed in the server a week ago.  A variety of Perl, PHP, shell and perhaps other scripts read read from the database, write records to the database, and otherwise shuffle data here, there and everywhere all day, every weekday.  Rebuilding the server from ground zero isn't a viable option.  I'm clueless what is dependent on anything else.  Because the system was built by a number of people over a period of many years, there is no one person who understands the system in its entirety . . . other than when something doesn't work it's a headache.  

Where do I begin the upgrade process?  What litmus test can I use to separate those who have the requisite skill to do the job and those who don't?  For someone with the necessary skills, what's a reasonable range of hours required for them to do what needs to be done?  

Thank you in advance for your insights and guidance.  







Responses

pgsql-novice by date

Next:From: Tom LaneDate: 2010-04-14 22:02:13
Subject: Re: Upgrading from PostgreSQL 7.4.3
Previous:From: Ognjen BlagojevicDate: 2010-04-14 15:21:20
Subject: Re: first steps

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group