Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 8FE159FA248 for ; Mon, 11 Dec 2006 10:45:34 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 40665-04 for ; Mon, 11 Dec 2006 10:45:10 -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.237]) by postgresql.org (Postfix) with ESMTP id C86949F9EED for ; Mon, 11 Dec 2006 10:45:09 -0400 (AST) Received: by nz-out-0102.google.com with SMTP id i11so771475nzh for ; Mon, 11 Dec 2006 06:45:08 -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=jh2hutnt8jEvQCoETWMKxioWHqOyqWrf4+OqwE2WzPi5LOvYEgeq5AU23wENZLkRvtWyj1YKChIeCNMa1MrVg+vJtzEo9TZgKAewBBlvo+ej1055maF6X48gPfWZWKXDLSRxVyzllaDf1G5WV6kaDuBTfv65fCdptX83Tyr0UIc= Received: by 10.64.199.2 with SMTP id w2mr11066315qbf.1165848308019; Mon, 11 Dec 2006 06:45:08 -0800 (PST) Received: by 10.65.206.18 with HTTP; Mon, 11 Dec 2006 06:45:07 -0800 (PST) Message-ID: Date: Mon, 11 Dec 2006 19:45:07 +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_59990_6587767.1165848307935" References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/147 X-Sequence-Number: 23939 ------=_Part_59990_6587767.1165848307935 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline All looks according to the logs to me... ----------- Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 12/11/06, Rajesh Kumar Mallah 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_59990_6587767.1165848307935 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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_59990_6587767.1165848307935--