Re: [BUGS] BUG #1744: Directory Missing

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
/>PostgreSQLversion: 8.0 <br />Operating system:   Solaris <br />Description:        Directory Missing <br />Details:
<p>Postmasteris 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 :
Thedatabase subdirectory <br />"/usr/local/pgsql/data/pg_tblspc/17231/17232" is <br />missing. <p>Note : CTBLISTDB is
thetable space created in the <br />PostGRESQL, where we create table and store the data. <p>I am starting the
Postmasterwhen the Solaris system <br />is coming up. This problem is not happening always. <br />But once the problem
ishappened I have to manually <br />clean the database and setup again or the backup to be <br />restore, which is not
acorrect solution. <p>I am not sure whether this is a bug or not. But I am <br />getting this problem frequently. What
isthe 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
joiningcolumn'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>