BUG #1744: Directory Missing

From: "K(dot)G(dot)Sivaraman" <ksivaram(at)ssd(dot)usa(dot)alcatel(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1744: Directory Missing
Date: 2005-07-01 14:18:48
Message-ID: 20050701141848.5A043F0B04@svr2.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers


The following bug has been logged online:

Bug reference: 1744
Logged by: K.G.Sivaraman
Email address: ksivaram(at)ssd(dot)usa(dot)alcatel(dot)com
PostgreSQL version: 8.0
Operating system: Solaris
Description: Directory Missing
Details:

Postmaster is successfully running after the install.
But after sometimes, I am facing the following problem.
Can some one suggests what is the problem ?.

ERROR : FATAL: database "CTBLISTDB" does not exist.
DETAIL : The database subdirectory
"/usr/local/pgsql/data/pg_tblspc/17231/17232" is
missing.

Note : CTBLISTDB is the table space created in the
PostGRESQL, where we create table and store the data.

I am starting the Postmaster when the Solaris system
is coming up. This problem is not happening always.
But once the problem is happened I have to manually
clean the database and setup again or the backup to be
restore, which is not a correct solution.

I am not sure whether this is a bug or not. But I am
getting this problem frequently. What is the cause and
what is the solution.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message K.G.Sivaraman 2005-07-01 14:30:02 BUG #1745: Unable to delete data from the database
Previous Message Dave Page 2005-07-01 14:13:26 Re: BUG #1735: row number -1 is out of range 0..-1 error

Browse pgsql-hackers by date

  From Date Subject
Next Message Andreas Pflug 2005-07-01 14:22:10 Re: enable/disable trigger (Re: Fwd: [HACKERS] Open items)
Previous Message Tom Lane 2005-07-01 14:03:57 Re: pl/pgsql: END verbosity [patch]