Search Postgresql Archives

BD removed

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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:

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!

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux