BD removed - Mailing list pgsql-general

From Miguel A. Lopera Tejero
Subject BD removed
Date
Msg-id 47F9D40F.1000304@dysmatica.es
Whole thread Raw
Responses Re: BD removed  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
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!

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Subtracting Two Intervals
Next
From: "Joshua D. Drake"
Date:
Subject: test ignore