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(at)potentialtech(dot)com> wrote in message
news:20090603114544(dot)434edcce(dot)wmoran(at)potentialtech(dot)com(dot)(dot)(dot)
> In response to "Carlos Oliva" <carlos(at)pbsinet(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>