From: Bruce Momjian <maillist@candle.pha.pa.us>
To: dg@illustra.com
Cc: brett@work.chicken.org
Cc: lockhart@alumni.caltech.edu
Cc: hackers@postgreSQL.org
Subject: Re: [HACKERS] Lots 'o patches
Date: Mon, 1 Jun 1998 10:24:48 -0400 (EDT)
Message-ID: <199806011424.KAA08421@candle.pha.pa.us> (raw)
In-Reply-To: <9806010654.AA27957@hawk.illustra.com>
> One of the Illustra customers moving to Informix UDO that I have had the
> pleasure of working with is Egghead software. They sell stuff over the web.
> 24 hours a day. Every day. Their database takes something like 20 hours to
> dump and reload. The last time they did that they were down the whole time
> and it made the headline spot on cnet news. Not good. I don't think they
> want to do it again.
>
> If we want postgresql to be usable by real businesses, requiring downtime is
> not acceptable.
>
> A proper upgrade would just update the catalogs online and fix any other
> issues without needing a dump / restore cycle.
>
> As a Sybase customer once told one of our support people in a very loud voice
> "THIS is NOT a "Name and Address" database. WE SELL STOCKS!".
That is going to be difficult to do. We used to have some SQL scripts
that could make the required database changes, but when system table
structure changes, I can't imagine how we would migrate that without a
dump/reload. I suppose we could keep the data/index files with user data,
run initdb, and move the data files back, but we need the system table
info reloaded into the new system tables.
--
Bruce Momjian | 830 Blythe Avenue
maillist@candle.pha.pa.us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: maillist@candle.pha.pa.us, dg@illustra.com, brett@work.chicken.org, lockhart@alumni.caltech.edu, hackers@postgreSQL.org
Subject: Re: [HACKERS] Lots 'o patches
In-Reply-To: <199806011424.KAA08421@candle.pha.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox