Skip site navigation (1) Skip section navigation (2)

Re: Upgrading databases

From: Bosco Rama <postgres(at)boscorama(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Upgrading databases
Date: 2009-11-11 18:58:43
Message-ID: 4AFB0963.9080608@boscorama.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfaces
Mark Richardson wrote:
> Sorry if this is in the wrong list, but this is the closest I could find...
>  
> I have a 8.2.4 database and I installed 8.3.7 and tried using the same
> /pgsql/data/base directory and got an error about incompatiblity.
>  
> The database currently has billions of records but it's sparsely populated.
> It took about 4 months to just populate the original database and I REALLY
> don't want to do that again.
>  
> Is there a conversion routine to change the files themselves? I know I can
> dump and reload - but that takes large disk space and time.  Any other way
> around?

There is no 'in-situ' DB upgrade between major updates from what I can
tell.  There is, however, an alternative to the 'dump to disk' approach
which is to pipe the dump from the old DB to the new DB as outlined in
the migration guide here:
    <http://www.postgresql.org/docs/8.3/static/migration.html>

HTH.

Bosc.

In response to

pgsql-interfaces by date

Next:From: Greg Sabino MullaneDate: 2009-11-14 15:28:55
Subject: Re: Upgrading databases
Previous:From: Kevin KempterDate: 2009-11-11 18:51:42
Subject: Re: Upgrading databases

pgsql-general by date

Next:From: David KerrDate: 2009-11-11 19:01:41
Subject: Re: Postgres Clustering Options
Previous:From: Kevin KempterDate: 2009-11-11 18:51:42
Subject: Re: Upgrading databases

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group