Postgres Pro
Downloads
Home   >   mailing lists

Upgrading databases - Mailing list pgsql-interfaces

From Mark Richardson
Subject Upgrading databases
Date
Msg-id 757407.82692.qm@web53304.mail.re2.yahoo.com
Whole thread Raw
Responses Re: Upgrading databases  (Kevin Kempter <kevink@consistentstate.com>)
Re: Upgrading databases  (Bosco Rama <postgres@boscorama.com>)
Re: Upgrading databases  ("Greg Sabino Mullane" <greg@turnstep.com>)
List pgsql-interfaces
Tree view
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

pgsql-interfaces by date:

Previous
From: Raimon Fernandez
Date:
Subject: Re: Implementing Frontend/Backend Protocol
Next
From: Kevin Kempter
Date:
Subject: Re: Upgrading databases