I have done that for one server today. But it would be a real pain to do that for other servers that I do not have convenient access to. And I sometimes need to install from DVD only without access to the internet to pull from backports. Jason On Thu, May 6, 2010 at 12:09 AM, Iñigo Martinez Lasala <imartinez@xxxxxxxxxxxx> wrote: > Why don't you use postgres 8.4 from lenny-backports? > > Lenny comes with postgres 8.3, but you can add postgresql 8.4 from backports > without problem. We have our production servers with lenny and postgresql > 8.4. No issues. > > Detailed instructions here: > http://www.backports.org/dokuwiki/doku.php?id=instructions > > Squeeze is almost ready. So, I think it's better to go with postgres 8.4 now > and upgrade lenny to squeeze in a few months without taking care about > postgres in the future. > > -----Original Message----- > From: Jason Tan Boon Teck <tanboonteck@xxxxxxxxx> > To: pgsql-admin@xxxxxxxxxxxxxx > Subject: Downgrading v8.4 database to v8.3 > Date: Wed, 5 May 2010 23:48:02 +0800 > > Hi, > > I use Debian GNU/Linux on various servers. Debian Stable a.k.a. Lenny > comes with PostgreSQL v8.3 while Debian Testing a.k.a Squeeze provides > PostgreSQL v8.4. > > I need to move some databases written in Psql v8.4 to the stable > production server running v8.3. I tried pg_dump and pg_restore as well > as PgAdmin3. I am unable to do so due to the backward > incompatibility. Is there anyway to do this? > > Thanks in advance. > > -- > Jason Tan Boon Teck > > > -- Jason Tan Boon Teck -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
