Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 6BBE82E0241 for ; Tue, 4 Mar 2008 01:04:57 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 21010-10 for ; Tue, 4 Mar 2008 01:04:51 -0400 (AST) X-Greylist: delayed 00:23:00.674099 by SQLgrey-1.7.5 Received: from primesoft.ph (unknown [203.215.70.7]) by postgresql.org (Postfix) with ESMTP id D29EE2E01BC for ; Tue, 4 Mar 2008 01:04:50 -0400 (AST) Date: Tue, 4 Mar 2008 12:41:57 +0800 Message-Id: <200803041241.AA26738978@primesoft.ph> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii From: "chris.jurado" Reply-To: To: Subject: Replacing the corrupt "global" folder with older one X-Mailer: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.1 tagged_above=0 required=5 tests=RDNS_NONE=0.1 X-Spam-Level: X-Archive-Number: 200803/26 X-Sequence-Number: 28509 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