| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Kempter | 2009-11-11 18:51:42 | Re: Upgrading databases |
| Previous Message | Greg Smith | 2009-11-11 18:35:58 | Re: Postgres Clustering Options |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kevin Kempter | 2009-11-11 18:51:42 | Re: Upgrading databases |
| Previous Message | Raimon Fernandez | 2009-11-02 21:57:30 | Re: Cancelling Requests Frontend/Backend Protocol TCP/IP |