BUG #1744: Directory Missing
The following bug has been logged online:
Bug reference: 1744
Logged by: K.G.Sivaraman
Email address: ksivaram@ssd.usa.alcatel.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.
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
Hi,
<p>Since I didn't get any response, I am just posting in pgsql-hackers.
<br>Can any one help ?.
<p>Thanks
<br>Siva
<p>> "K.G.Sivaraman" wrote:
<blockquote TYPE=CITE>The following bug has been logged online:
<p>Bug reference: 1744
<br>Logged by: K.G.Sivaraman
<br>Email address: ksivaram@ssd.usa.alcatel.com
<br>PostgreSQL version: 8.0
<br>Operating system: Solaris
<br>Description: Directory Missing
<br>Details:
<p>Postmaster is successfully running after the install.
<br>But after sometimes, I am facing the following problem.
<br>Can some one suggests what is the problem ?.
<p>ERROR : FATAL: database "CTBLISTDB" does not exist.
<br>DETAIL : The database subdirectory
<br>"/usr/local/pgsql/data/pg_tblspc/17231/17232" is
<br>missing.
<p>Note : CTBLISTDB is the table space created in the
<br>PostGRESQL, where we create table and store the data.
<p>I am starting the Postmaster when the Solaris system
<br>is coming up. This problem is not happening always.
<br>But once the problem is happened I have to manually
<br>clean the database and setup again or the backup to be
<br>restore, which is not a correct solution.
<p>I am not sure whether this is a bug or not. But I am
<br>getting this problem frequently. What is the cause and
<br>what is the solution.
<p>---------------------------(end of broadcast)---------------------------
<br>TIP 9: In versions below 8.0, the planner will ignore your desire to
<br> choose an index scan if your joining
column's datatypes do not
<br> match</blockquote>
<pre>--
K.G.Sivaraman, Axes Technologies (I) Pvt Ltd
"The only SERVICE to be done for our lower classes is to give them
EDUCATION, to develop their lost individuality" - Swami Vivekananda</pre>
</html>