Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Lots 'o patches

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: dg(at)illustra(dot)com (David Gould)
Cc: brett(at)work(dot)chicken(dot)org, lockhart(at)alumni(dot)caltech(dot)edu, hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] Lots 'o patches
Date: 1998-06-01 14:24:48
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
> 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(at)candle(dot)pha(dot)pa(dot)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)

In response to


pgsql-hackers by date

Next:From: Brett McCormickDate: 1998-06-01 14:27:50
Subject: Re: [HACKERS] regular expressions from hell
Previous:From: Bruce MomjianDate: 1998-06-01 14:16:35
Subject: Re: [HACKERS] regular expressions from hell

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group