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

Upgrading databases

From: Mark Richardson <markmapo(at)yahoo(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Upgrading databases
Date: 2009-11-11 18:38:31
Message-ID: 757407.82692.qm@web53304.mail.re2.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfaces
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?
 
Thanks,
Mark


      

Responses

pgsql-interfaces by date

Next:From: Kevin KempterDate: 2009-11-11 18:51:42
Subject: Re: Upgrading databases
Previous:From: Raimon FernandezDate: 2009-11-02 21:57:30
Subject: Re: Cancelling Requests Frontend/Backend Protocol TCP/IP

pgsql-general by date

Next:From: Kevin KempterDate: 2009-11-11 18:51:42
Subject: Re: Upgrading databases
Previous:From: Greg SmithDate: 2009-11-11 18:35:58
Subject: Re: Postgres Clustering Options

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