On Fri, 2005-02-25 at 09:20 -0800, Si Chen wrote: > Thanks! > > Is there any documentation on how to upgrade to 8.0? > > Is it possible to upgrade from 7.4 to 8.0 while keeping a production > database running "in place"? Or should I install 8.0 in another > directory/machine and then restore the database into it? Are there any > incompatibilities/modifications to databases from the earlier veresion > required? >
You might want to check out Slony-I <http://www.slony.info> for the purpose of upgrading. Slony is actually a replication engine, but it can be used to upgrade with little or no downtime. Otherwise, just dump/upgrade/restore like normal. As far as compatibility, 8.0 should be mostly backwards compatible. There may be some minor things that I don't know about, so I recommend some testing first. Regards, Jeff Davis ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
