Thread: md_open problem

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

Rommel B. Abaya <rommel.abaya@ramcargroup.com> 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/<name>/<tablename> PostgreSQL is complaining about
  into existence
- drop the table
- recreate the table

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