Re: Corrupt view in PostgreSQL 9.0.9

Поиск
Список
Период
Сортировка
От Mikael Kjellström
Тема Re: Corrupt view in PostgreSQL 9.0.9
Дата
Msg-id 5065E34C.7030109@mksoft.nu
обсуждение исходный текст
Ответ на Re: Corrupt view in PostgreSQL 9.0.9  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
On 2012-09-28 19:39, Tom Lane wrote:
> Mikael Kjellström <mikael.kjellstrom@mksoft.nu> writes:
>> Your recomendation is to restore the backup to a new database and drop
>> the old one, right?
>
> Right.  If you've got more than one active database in this
> installation, it might be prudent to dump and restore the whole thing
> --- but in any case, you don't want to trust this database's
> pg_attribute anymore.

Ok.  I've done just that.  I dumped the database, dropped it and then
created it and restored the backup.  All the data seems to be there also
at a first glance.

I also took the oppertunity to compile and upgrade to 9.0.10 when I had
the chance.

Thanks for all the help.

/Mikael



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Corrupt view in PostgreSQL 9.0.9
Следующее
От: mr.dash.four@googlemail.com
Дата:
Сообщение: BUG #7575: "between" does not work properly with inet/cidr addresses