8.1 beta1 -> beta2 upgrade question

From: Eric Sproul <esproul(at)omniti(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: 8.1 beta1 -> beta2 upgrade question
Date: 2005-10-12 17:00:24
Message-ID: 1129136424.6993.26.camel@dagger.office.omniti.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,
I am a systems admin for OmniTI Inc. I'm posting this question at the
request of my boss, Theo Schlossnagle. I am new to Postgres, but Theo
has asked me to engage some developers for help, so please bear with me
and forgive my ignorance.

We are testing a 1TB database on 8.1 beta 1. The upgrade path to beta 2
(and presumably from beta 2 to the next release, all the way through
production) requires a full export and import. Even on our beefy
hardware (quad-Opteron, 16GB RAM) we are looking at a 26-hour complete
outage for every upgrade (and back-out if something doesn't work
properly). We are interested in finding a way to directly translate the
data files from one version to the next. We can devote resources to
work on this if the development team can give us guidance.

Thanks in advance,
Eric Sproul

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2005-10-12 17:44:50 Re: Spinlocks, yet again: analysis and proposed patches
Previous Message Tom Lane 2005-10-12 16:45:14 pgsql: Do all accesses to shared buffer headers through