md_open problem

Поиск
Список
Период
Сортировка
Искать

md_open problem

От:
"Rommel B. Abaya" <rommel.abaya@ramcargroup.com>
Дата:
hi,

this has occured to me quite often and im out of solution for this. how
do you address an md_open() problem in PostgreSQL? It occurs everytime
the Linux box goes on power failure while transactions are being
commited to the database. I can do access the other tables but i'm
having difficulty on some.

i also try dropping the tables but i get the same md_open error.

hope somebody can help me...

TIA

Re: md_open problem

От:
jdassen@cistron.nl (J.H.M. Dassen (Ray))
Дата:
Rommel B. Abaya  wrote:
>this has occured to me quite often and im out of solution for this. how do
>you address an md_open() problem in PostgreSQL? It occurs everytime the
>Linux box goes on power failure while transactions are being commited to
>the database.

>i also try dropping the tables but i get the same md_open error.

I'm not sure I recall the exact sequence to fix things, but I believe it is
- touch(1) the data/base// PostgreSQL is complaining about
  into existence
- drop the table
- recreate the table

HTH,
Ray
-- 
Brought to you by Microsoft .NOT technology: just say No.
FAQ