<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
</head>
<body bgcolor="#ffffff" text="#000000">
Hi there,<br>
<br>
I need some help. We have a Web application connecting to a postgresql
8.2 database on Windows Server 2003. According to the log, we logged on
the server using a remote control desktop, after uninstalling Tomcat we
installed a new Tomcat version. After that, we shutted down the
Postgres service and restarted the service again.<br>
<br>
The problem is that the folder where the tablespace of the database is
placed has been removed.<br>
<br>
This is the log:<br>
<blockquote cite="mid:47F9CC54(dot)1090408(at)dysmatica(dot)es" type="cite"><font
face="Arial" size="2"><font face="Arial" size="2"><br>
2008-04-04 09:40:15 LOG: unexpected EOF on client connection <br>
2008-04-04 09:40:15 LOG: unexpected EOF on client connection <br>
2008-04-04 09:45:51 LOG: unexpected EOF on client connection <br>
2008-04-04 13:01:58 FATAL: database "bdaplicacion" does not exist <br>
2008-04-04 13:01:58 DETAIL: The database subdirectory
"pg_tblspc/16404/16405" is missing. <br>
2008-04-04 13:03:58 FATAL: database "bdaplicacion" does not exist <br>
2008-04-04 13:03:58 DETAIL: The database subdirectory
"pg_tblspc/16404/16405" is missing. <br>
2008-04-04 13:05:59 FATAL: database "bdaplicacion" does not exist <br>
2008-04-04 13:05:59 DETAIL: The database subdirectory
"pg_tblspc/16404/16405" is missing. <br>
2008-04-04 13:07:59 FATAL: database "bdaplicacion" does not exist <br>
2008-04-04 13:07:59 DETAIL: The database subdirectory
"pg_tblspc/16404/16405" is missing. <br>
2008-04-04 13:09:33 FATAL: database "bdaplicacion" does not exist <br>
2008-04-04 13:09:33 DETAIL: The database subdirectory
"pg_tblspc/16404/16405" is missing. <br>
2008-04-04 13:10:01 FATAL: database "bdaplicacion" does not exist <br>
2008-04-04 13:10:01 DETAIL: The database subdirectory
"pg_tblspc/16404/16405" is missing. <br>
2008-04-04 13:10:02 FATAL: database "bdaplicacion" does not exist <br>
2008-04-04 13:10:02 DETAIL: The database subdirectory
"pg_tblspc/16404/16405" is missing. <br>
2008-04-04 13:12:02 FATAL: database "bdaplicacion" does not exist <br>
2008-04-04 13:12:02 DETAIL: The database subdirectory
"pg_tblspc/16404/16405" is missing. <br>
2008-04-04 13:14:02 FATAL: database "bdaplicacion" does not exist <br>
2008-04-04 13:14:02 DETAIL: The database subdirectory
"pg_tblspc/16404/16405" is missing. <br>
2008-04-04 13:16:02 FATAL: database "bdaplicacion" does not exist <br>
2008-04-04 13:16:02 DETAIL: The database subdirectory
"pg_tblspc/16404/16405" is missing. <br>
2008-04-04 13:18:03 FATAL: database "bdaplicacion" does not exist <br>
2008-04-04 13:18:03 DETAIL: The database subdirectory
"pg_tblspc/16404/16405" is missing. <br>
2008-04-04 13:20:03 FATAL: database "bdaplicacion" does not exist <br>
2008-04-04 13:20:03 DETAIL: The database subdirectory
"pg_tblspc/16404/16405" is missing. <br>
2008-04-04 13:22:03 FATAL: database "bdaplicacion" does not exist <br>
2008-04-04 13:22:03 DETAIL: The database subdirectory
"pg_tblspc/16404/16405" is missing. <br>
2008-04-04 13:22:06 LOG: received fast shutdown request <br>
2008-04-04 13:22:06 LOG: shutting down <br>
2008-04-04 13:22:06 LOG: database system is shut down <br>
2008-04-04 13:22:07 LOG: logger shutting down <br>
<br>
2008-04-04 13:22:52 LOG: database system was shut down at 2008-04-04
13:22:06 Hora de verano romance <br>
2008-04-04 13:22:52 LOG: checkpoint record is at 0/274ED648 <br>
2008-04-04 13:22:52 LOG: redo record is at 0/274ED648; undo record is
at 0/0; shutdown TRUE <br>
2008-04-04 13:22:52 LOG: next transaction ID: 0/1192198; next OID:
17381 <br>
2008-04-04 13:22:52 LOG: next MultiXactId: 27; next MultiXactOffset: 53
<br>
2008-04-04 13:22:52 LOG: database system is ready <br>
2008-04-04 13:23:53 FATAL: database "bdaplicacion" does not exist <br>
2008-04-04 13:23:53 DETAIL: The database subdirectory
"pg_tblspc/16404/16405" is missing. <br>
<br>
Alguien sabe que ha podido pasar y como podemos recuperarlo.</font></font></blockquote>
<br>
Does anybody know what happened? and how can we recover the folder?<br>
<br>
Thanks in advance!
</body>
</html>