From: chris.jurado <chris.jurado@primesoft.ph>
To: pgsql-admin@postgresql.org
Subject: Replacing the corrupt "global" folder with older one
Date: Tue, 4 Mar 2008 12:41:57 +0800
Message-ID: <200803041241.AA26738978@primesoft.ph> (raw)
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).
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?
--------------------------------------------------------------
Christopher Brian L. Jurado
Big Smile Interactive
Primary Sotware Development Corporation
www.primesoft.ph
________________________________________________________________
Sent via the WebMail system at primesoft.ph
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: chris.jurado@primesoft.ph
Subject: Re: Replacing the corrupt "global" folder with older one
In-Reply-To: <200803041241.AA26738978@primesoft.ph>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox