On Fri, Dec 21, 2007 at 10:53:49AM -0500, beer@xxxxxxx wrote: > I am trying to upgrade my database from 8.0 to 8.1 and am looking for a > little info/advice. > > This is a production database that we are migrating and it is in CONSTANT > use, so the maintenance window must be small and hopefully mostly off-hours. The usual answer is use slony. You can use it to replicate the 8.0 server onto an 8.1 server. This may take weeks/months/years/whatever to synchronise. When the slave is up to date, you pull the plug on the 8.0 server and get everyone to use the 8.1 server... No downtime... Have a nice day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > Those who make peaceful revolution impossible will make violent revolution inevitable. > -- John F Kennedy
Attachment:
signature.asc
Description: Digital signature
