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@serensoft.com
http://groups.yahoo.com/group/newbieDoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!