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!

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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general