On Wed, Mar 12, 2008 at 8:17 PM, Robert Treat <xzilla@xxxxxxxxxxxxxxxxxxxxx> wrote: > On Wednesday 12 March 2008 01:27, sathiya psql wrote: > > Is there any article describing the migration database from postgresql > > 7.4to 8.1 > > I don't know of any specific references, but the process is not fundementally > different from any other major version upgrade. You'll want to do a schema > only dump of your current database any load that into the 8.1 database. Once > you feel comfortable that this works ok, try a data only dump and load that > into the 8.1 server. Once you comfortable all that works, you're ready to > upgrade. > > I will note that if you're planning to upgrade, I'd recommend going stright to > 8.3. 8.1 is a few years old, and 8.3 provides a number of features and > improvement you'll benefit from. Unless you have a strong reason to do > otherwise, go to 8.3. HTH. And if the OP is worried about running too new a version of pgsql, 8.2.6 is very mature. But if he's got 6 or more months until he goes live, which is common, I'd recommend going to 8.3 which will be well polished by then. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
