Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id C872B9FA1DE for ; Mon, 11 Dec 2006 10:45:58 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 66448-10 for ; Mon, 11 Dec 2006 10:45:35 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from nz-out-0102.google.com (nz-out-0506.google.com [64.233.162.226]) by postgresql.org (Postfix) with ESMTP id AAD959F9EED for ; Mon, 11 Dec 2006 10:45:46 -0400 (AST) Received: by nz-out-0102.google.com with SMTP id i11so771576nzh for ; Mon, 11 Dec 2006 06:45:45 -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:in-reply-to:mime-version:content-type:references; b=cdwIdk+8ZcFXSDQWcpj0Ti8Nk+1wkL0e5S3TuRac90Z6gS+NEHtDfe4DLtnWPt2+igctHJGVBBbuZWKxNe1xf3eoxZH3UtcVeUXS64lhaXfXiAHtG2XiHNueRLfJ1XwmpPdcVYBcrhB6L/29awpwKKUToylUpGoelwciLEHkYjk= Received: by 10.65.180.7 with SMTP id h7mr11024227qbp.1165848344197; Mon, 11 Dec 2006 06:45:44 -0800 (PST) Received: by 10.65.206.18 with HTTP; Mon, 11 Dec 2006 06:45:44 -0800 (PST) Message-ID: Date: Mon, 11 Dec 2006 19:45:44 +0500 From: "Shoaib Mir" To: "Rajesh Kumar Mallah" Subject: Re: how to recover database back from /data folder [ Possibly Recovered ] Cc: "yogesh@banasdairy.coop" , "Lista Postgres" In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_60002_29334357.1165848344157" References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/148 X-Sequence-Number: 23940 ------=_Part_60002_29334357.1165848344157 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline I meant "all looks *good* according to the logs" :) ----------- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 12/11/06, Shoaib Mir wrote: > > All looks according to the logs to me... > > ----------- > Shoaib Mir > EnterpriseDB (www.enterprisedb.com) > > On 12/11/06, Rajesh Kumar Mallah < mallah.rajesh@gmail.com> wrote: > > > > 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. > > > > ------=_Part_60002_29334357.1165848344157 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline I meant "all looks *good* according to the logs" :)

-----------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 12/11/06, Shoaib Mir <shoaibmir@gmail.com > wrote:
All looks according to the logs to me...

-----------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)


On 12/11/06, Rajesh Kumar Mallah < mallah.rajesh@gmail.com> wrote:
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.


------=_Part_60002_29334357.1165848344157--