[OT] PostGres Upgrade for Debian Sarge [Was: Re: pg_restore]

On Fri, Mar 03, 2006 at 05:19:49AM -0800, Marco Rossi wrote:

> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

>> Is there a good reason you aren't running a more modern Postgres
>> release?

> Postgres has not been upgrade in debian sarge (stable) release ... but
> if they ain't no other workaroud I'll consider a system upgrade.

Marco (and anyone else who might be interested):

If you'd like to upgrade Postgres and still remain with Sarge, Martin
Pitt, the actual Postgres maintainer, keeps up-to-date Postgres
backports for Debian Sarge at
http://people.debian.org/~mpitt/packages/sarge-backports

The sources.list line that I use is:

deb http://people.debian.org/~mpitt/packages/sarge-backports/ /

The current version there is 8.1.3, plus I think he also keeps updated
7.X versions, too.

I've been using his 8.1 branch for a few months for my personal database
and it seems quite stable. When I upgraded from 7.4.7 to 8.0 (I began
with 8.0), of course I made dumps of my database, but it upgraded the DB
without a hitch.