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.