Craig Ringer wrote:
> On 29/09/2010 5:11 PM, aswin jayaraman wrote:
> > I ll try that out.Is there means to do an upgrade to 8.3 to 8.4/9.0 with
> > the data in place?
>
> No, it requires a dump and reload. Sorry. You'll want to read the
> release notes, as there have been changes between 8.3 and 9.0 that may
> affect applications.
>
> http://www.postgresql.org/docs/9/static/release-8-4.html
> http://www.postgresql.org/docs/9/static/release-9-0.html
>
> PostgreSQL has seen significant improvements in the Windows port, so
> it's worth the update. I unfortunately cannot promise that it'll fix the
> issue you're having, though.
pg_upgrade works for upgrades from 8.3 to 9.0.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
