Restoring 8.0 db to 8.1

From: "beer(at)cmu(dot)edu" <beer(at)cmu(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Restoring 8.0 db to 8.1
Date: 2007-12-21 15:53:49
Message-ID: 7916966e0712210753w599c2699ia427a03e9dc8fe80@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

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.

We use a PITR/LVM snapshot solution for our backups and were hoping to
simply restore the filesystem and startup under 8.1. Obviously this didnt
work, and I know the doc says a conversion is necessary, however I havent
found anything with enough detail to sway me from a better solution than
pg_restore.

The problem with pg_restore is that our database takes 3+ weeks to restore
from a dump file. This is not an acceptable window for us. ( Approximately
3 days of this is data + lobs, and the rest indexes and constraints. If we
are doing something wrong here, I am all ears as well )

Could anyone point me to the information I am missing or offer some middle
ground solutions?

TIA

Bill

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2007-12-21 16:04:18 Re: Restoring 8.0 db to 8.1
Previous Message Merlin Moncure 2007-12-21 14:06:16 Re: Conditional updateable view