[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    [ADMIN] Re: md_open problem
From:       jdassen () cistron ! nl (J ! H ! M !  Dassen (Ray))
Date:       2001-01-26 14:23:58
[Download RAW message or body]

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.

[prev in list] [next in list] [prev in thread] [next in thread]