BD removed

Поиск
Список
Период
Сортировка
От Miguel A. Lopera Tejero
Тема BD removed
Дата
Msg-id 47F9D40F.1000304@dysmatica.es
обсуждение исходный текст
Ответы Re: BD removed
Список 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 по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Subtracting Two Intervals
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: test ignore