Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 4B5B29FA2EC for ; Mon, 11 Dec 2006 10:08:18 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 68907-01 for ; Mon, 11 Dec 2006 10:07:37 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.177]) by postgresql.org (Postfix) with ESMTP id 072189F9F47 for ; Mon, 11 Dec 2006 10:07:42 -0400 (AST) Received: by py-out-1112.google.com with SMTP id a73so411856pye for ; Mon, 11 Dec 2006 06:07:41 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:mime-version:content-type:content-transfer-encoding:content-disposition; b=My1UyuS4FEx2fTKA3SMQi2FGKs75Tz2Jhm5RiyQiF9uGAmN76MJBMVPfgqvDeRACU5yBWW4nr1LSZB57/lFlm76TS7sqn2JNGpixSHfca2IIZ+KXpq7TZRaeG/04P5tTQUKpAqy1A2cq2x5GSUXrjuMiLmR1RvstOygVq5dsSDs= Received: by 10.35.50.1 with SMTP id c1mr5746580pyk.1165846061275; Mon, 11 Dec 2006 06:07:41 -0800 (PST) Received: by 10.35.80.10 with HTTP; Mon, 11 Dec 2006 06:07:41 -0800 (PST) Message-ID: Date: Mon, 11 Dec 2006 19:37:41 +0530 From: "Rajesh Kumar Mallah" To: "Shoaib Mir" Subject: Re: how to recover database back from /data folder [ Possibly Recovered ] Cc: "yogesh@banasdairy.coop" , "Lista Postgres" MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/145 X-Sequence-Number: 23937 Hi List , I restored the filesystem backup tar and ran postgres 7.3.8 on the data folder. there was no problem at all. DEBUG: FindExec: found "/opt/usr/local/pgsql7.3/bin/postgres" using argv[0] DEBUG: invoking IpcMemoryCreate(size=1466368) DEBUG: FindExec: found "/opt/usr/local/pgsql7.3/bin/postmaster" using argv[0] LOG: database system was shut down at 2006-12-04 12:30:21 IST LOG: checkpoint record is at 0/39DF3C2C LOG: redo record is at 0/39DF3C2C; undo record is at 0/0; shutdown TRUE LOG: next transaction id: 2006905; next oid: 15212626 LOG: database system is ready DEBUG: proc_exit(0) DEBUG: shmem_exit(0) DEBUG: exit(0) DEBUG: reaping dead processes I think the above messages support the fact that the database was shutdown properly before the filesystem level backup. Can anyone kindly confirm it ? I listed the tables and did some selects the data seems to be there. I think postgres was not starting for some peripheral issues not because that data folder was corrupted. BTW when i first started postmaster it gave an error related to too liberal permissions. Probably the original poster was doing the same mistake. Regds mallah.