On Wed, 2011-10-26 at 09:00 -0400, Henry Drexler wrote:
>
>
> On Wed, Oct 26, 2011 at 4:40 AM, Dagan <mail.list@pro.geek.nz> wrote:
> Hi all,
>
> I notice that Postgresql 9.1 is available in the backports
> for Debian
> Squeeze. I note that it installed side-by-side with version
> 9.0, which I
> already have running a small database.
>
> Is there a best-practice for upgrading from one version to
> another?
> Do I need to manually dump the database from 9.0, and import
> into 9.1?
>
> Cheers,
> Dagan
> http://www.postgresql.org/docs/current/static/pgupgrade.html
I found Debian provides it's own set of wrapper scripts, in this case
pg_upgradecluster
Dagan