Re: Upgrading Database: need to dump and restore?

For large databases or tables, this will take a long time to do.  Are there
any alternatives to benefit from the improved versions of PostgreSQL without
having to dump some large tables that never change?
"Bill Moran" <wmoran@potentialtech.com> wrote in message
news:20090603114544.434edcce.wmoran@potentialtech.com...
> In response to "Carlos Oliva" <carlos@pbsinet.com>:
>
>> If I were to upgrade the database version, would I need to dump and
>> restore
>> all the data?
>
> If you upgrade patch releases (i.e. from 8.3.4 -> 8.3.5) then usually no,
> but see the release notes for the versions you're upgrading, because there
> are occasionally exceptions.
>
> If you're updating to a major release (8.2.x -> 8.3.x), then yes.
>
> --
> Bill Moran
> http://www.potentialtech.com
> http://people.collaborativefusion.com/~wmoran/
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>