upgrade broke stuff, downgrade still broke
От | will trillich |
---|---|
Тема | upgrade broke stuff, downgrade still broke |
Дата | |
Msg-id | 20010227160603.A28401@mail.serensoft.com обсуждение исходный текст |
Ответы |
Re: upgrade broke stuff, downgrade still broke
|
Список | 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@serensoft.com http://groups.yahoo.com/group/newbieDoc -- we need your brain! http://www.dontUthink.com/ -- your brain needs us!
В списке pgsql-general по дате отправления: