upgrade broke stuff, downgrade still broke

From: will trillich <will(at)serensoft(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: upgrade broke stuff, downgrade still broke
Date: 2001-02-27 22:06:03
Message-ID: 20010227160603.A28401@mail.serensoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi. i've got a little database going on debian (potato) and
i tried updating my postgresql to 7.0.3 (from 6.5.3). there
were no fancy plpgsql procedures, no foreign keys (references),
nothing very advanced at all. just about five tables, a few
views, and a sequence (serial type).

i did the debian
apt-get update && apt-get upgrade
to install the 7.0.3potato* version from www.samfundet.no/~tfheen
and during the upgrade a view turned into an empty table, and
some other tables disappeared altogether.

then i did
apt-get --purge remove postgres*
(keeping data directories intact) and then
dpkg -i postgres*6.5.3*
to force the reinstallation of the oldder server engine.

now i have an existing database (psql 'mydb' selects the
database) but there are no tables, no views, no indexes,
no series...

any suggestions welcome. (i'm figuring out how to automate
backups now, and thanks for the idea. :) :( :)

--
It is always hazardous to ask "Why?" in science, but it is often
interesting to do so just the same.
-- Isaac Asimov, 'The Genetic Code'

will(at)serensoft(dot)com
http://groups.yahoo.com/group/newbieDoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-02-27 22:17:02 Re: Odd behavior with views and numeric columns
Previous Message Dominic J. Eidson 2001-02-27 21:56:47 Re: Re: Query precompilation?