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@xxxxxxxxxxxxxxxxx> wrote in message news:20090603114544.434edcce.wmoran@xxxxxxxxxxxxxxxxxxxx > In response to "Carlos Oliva" <carlos@xxxxxxxxxxx>: > >> 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
