Thread: BD removed
Hi there, 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. The problem is that the folder where the tablespace of the database is placed has been removed. This is the log: <font face="Arial" size="2"> 2008-04-04 09:40:15 LOG: unexpected EOF on client connection 2008-04-04 09:40:15 LOG: unexpected EOF on client connection 2008-04-04 09:45:51 LOG: unexpected EOF on client connection 2008-04-04 13:01:58 FATAL: database "bdaplicacion" does not exist 2008-04-04 13:01:58 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing. 2008-04-04 13:03:58 FATAL: database "bdaplicacion" does not exist 2008-04-04 13:03:58 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing. 2008-04-04 13:05:59 FATAL: database "bdaplicacion" does not exist 2008-04-04 13:05:59 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing. 2008-04-04 13:07:59 FATAL: database "bdaplicacion" does not exist 2008-04-04 13:07:59 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing. 2008-04-04 13:09:33 FATAL: database "bdaplicacion" does not exist 2008-04-04 13:09:33 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing. 2008-04-04 13:10:01 FATAL: database "bdaplicacion" does not exist 2008-04-04 13:10:01 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing. 2008-04-04 13:10:02 FATAL: database "bdaplicacion" does not exist 2008-04-04 13:10:02 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing. 2008-04-04 13:12:02 FATAL: database "bdaplicacion" does not exist 2008-04-04 13:12:02 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing. 2008-04-04 13:14:02 FATAL: database "bdaplicacion" does not exist 2008-04-04 13:14:02 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing. 2008-04-04 13:16:02 FATAL: database "bdaplicacion" does not exist 2008-04-04 13:16:02 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing. 2008-04-04 13:18:03 FATAL: database "bdaplicacion" does not exist 2008-04-04 13:18:03 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing. 2008-04-04 13:20:03 FATAL: database "bdaplicacion" does not exist 2008-04-04 13:20:03 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing. 2008-04-04 13:22:03 FATAL: database "bdaplicacion" does not exist 2008-04-04 13:22:03 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing. 2008-04-04 13:22:06 LOG: received fast shutdown request 2008-04-04 13:22:06 LOG: shutting down 2008-04-04 13:22:06 LOG: database system is shut down 2008-04-04 13:22:07 LOG: logger shutting down 2008-04-04 13:22:52 LOG: database system was shut down at 2008-04-04 13:22:06 Hora de verano romance 2008-04-04 13:22:52 LOG: checkpoint record is at 0/274ED648 2008-04-04 13:22:52 LOG: redo record is at 0/274ED648; undo record is at 0/0; shutdown TRUE 2008-04-04 13:22:52 LOG: next transaction ID: 0/1192198; next OID: 17381 2008-04-04 13:22:52 LOG: next MultiXactId: 27; next MultiXactOffset: 53 2008-04-04 13:22:52 LOG: database system is ready 2008-04-04 13:23:53 FATAL: database "bdaplicacion" does not exist 2008-04-04 13:23:53 DETAIL: The database subdirectory "pg_tblspc/16404/16405" is missing. Alguien sabe que ha podido pasar y como podemos recuperarlo. Does anybody know what happened? and how can we recover the folder? Thanks in advance!
Miguel A. Lopera Tejero escribió: > 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. > > The problem is that the folder where the tablespace of the database is > placed has been removed. I assume you understand that was a pretty silly thing to do. Do you have backups? -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support