Sorry for sending this directly to the hackers mailing list. But, i think it
did not belong in any other as it involves internals about the files in the
data directory.
PostgreSQL version: 8.1.2
Operating system: Windows XP/2003
The PostgreSQL service is not starting anymore. When I manually start it, it
said something like it started but ended immediately because it had no work to
do. I encountered this error before but a simple re-installation fixed it. This
time, it didn't.
I've tried running the service using a backup data folder w/c was 2 days ago,
it runs. When I switch back to the current, I get the error above. So, I
figured the current data must be corrupt. After examination of the data folder,
the global folder is now not a folder but a file that is 8KB in size (I found
this out by trying out the reset_xlog command and it said it could no longer
find the global/xxx file). It could be the hard disk has a problem. I'm going
to replace it soon.
I searched the documentation about what the global folder contains and found
out that these contain cluster-wide tables like the list of databases, etc.
I wanted not to lose the latest transactions by restoring a backup. Now the
question is this, is it ok to just copy the global folder from my backup 2 days
ago, and replace the one in my current data folder? I'm very very sure no DDL
statements were executed or no new databases/other objects were created since
my last backup. Only DML statements were executed on the user's databases. Will
I lose data if I do this?
________________________________________________________________
Sent via the WebMail system at primesoft.ph
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your Subscription:
http://mail.postgresql.org/mj/mj_wwwusr?domain=postgresql.org&extra=pgsql-hackers
