Re: Upgrading a database dump/restore - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Upgrading a database dump/restore
Date
Msg-id 4525630D.4080602@dunslane.net
Whole thread Raw
In response to Upgrading a database dump/restore  ("Mark Woodward" <pgsql@mohawksoft.com>)
Responses Re: Upgrading a database dump/restore
List pgsql-hackers
Mark Woodward wrote:
> I am currently building a project that will have a huge number of records,
> 1/2tb of data. I can't see how I would ever be able to upgrade PostgreSQL
> on this system.
>
>   

Slony will help you upgrade (and downgrade, for that matter) with no 
downtime at all, pretty much. Of course, you do need double the 
resources ....

You other suggestion of setting the on disk format in high viscosity 
jello, if not in concrete, seems doomed to failure. Cool features that 
you and other people want occasionally rely on format changes.

Of course, you don't have to upgrade every release. Many people 
(including me) don't.

cheers

andrew


pgsql-hackers by date:

Previous
From: "Mark Woodward"
Date:
Subject: Upgrading a database dump/restore
Next
From: Mark Wong
Date:
Subject: continuing daily testing of dbt2 against postgresql