pg_upgrade loses all data

Поиск
Список
Период
Сортировка
От Oliver Elphick
Тема pg_upgrade loses all data
Дата
Msg-id 199906072235.XAA14203@linda.lfix.co.uk
обсуждение исходный текст
Ответы Re: [HACKERS] pg_upgrade loses all data  (Bruce Momjian <maillist@candle.pha.pa.us>)
Список pgsql-hackers
Release 6.5beta2

I've used pg_upgrade to import data from 6.4.2.

The tables are created correctly, as far as I can see, but the data gets
lost, so that no tuples are visible in any table I have yet looked at.
The data is actually present, because I can see it if I use `od -c' on
a table's file, but select * reports no rows.

Any clues, please?


NB: If this experience is repeated by others, anyone who had not backed up
his data separately would lose it all (if the tables are not repairable).


-- 
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver              PGP key from public servers; key
ID32B8FAA1                ========================================    "There is a way that seems right to a man, but in
the     end it leads to death."                                              Proverbs 16:25 
 




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Egon Schmid
Дата:
Сообщение: Re: [HACKERS] PostgreSQL History(Parody)
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Pretty bad bug in Postgres.