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

From Mark Woodward
Subject Re: Upgrading a database dump/restore
Date
Msg-id 18402.24.91.171.78.1160080762.squirrel@mail.mohawksoft.com
Whole thread Raw
In response to Re: Upgrading a database dump/restore  (AgentM <agentm@themactionfaction.com>)
Responses Re: Upgrading a database dump/restore  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-hackers
>
> Indeed. The main issue for me is that the dumping and replication
> setups require at least 2x the space of one db. That's 2x the
> hardware which equals 2x $$$. If there were some tool which modified
> the storage while postgres is down, that would save lots of people
> lots of money.

Its time and money. Stoping a database and staring with new software is a
lot faster than dumping the data out (disallowing updates or inserts) and
restoring the data can take hours or days *and* twice the hardware.


pgsql-hackers by date:

Previous
From: AgentM
Date:
Subject: Re: Upgrading a database dump/restore
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Upgrading a database dump/restore