Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 111EFF6B3CC for ; Thu, 19 Apr 2012 18:55:16 -0300 (ADT) Received: from mx2.d2.com ([66.251.81.121]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SKzJp-0005I8-BI for pgsql-admin@postgresql.org; Thu, 19 Apr 2012 21:55:16 +0000 Received: from mxb.d2.com ([10.85.4.6]) by mx2.d2.com (8.13.8/8.13.8) with ESMTP id q3JMpREF012735 for ; Thu, 19 Apr 2012 15:51:27 -0700 X-ASG-Debug-ID: 1334872492-01d10a6c968da6d0001-ysJW5H Received: from mail01.d2.com ([172.16.66.171]) by mxb.d2.com with ESMTP id fRWr5SmdBkXpm5Oq for ; Thu, 19 Apr 2012 14:54:52 -0700 (PDT) X-Barracuda-Envelope-From: aalvarez@d2.com Received: from exbew2k3-02.d2.com (exbew2k3-02 [10.78.2.16]) by mail01.d2.com (8.13.8/8.13.8/Debian-3) with ESMTP id q3JLsqGK010803 for ; Thu, 19 Apr 2012 14:54:52 -0700 Received: from [10.126.2.222] ([10.126.2.222] RDNS failed) by exbew2k3-02.d2.com with Microsoft SMTPSVC(6.0.3790.3959); Thu, 19 Apr 2012 14:54:51 -0700 Message-ID: <4F9089AB.2060202@d2.com> Date: Thu, 19 Apr 2012 14:54:51 -0700 From: amador alvarez User-Agent: Mozilla/5.0 (X11; U; Linux i686 (x86_64); en-US; rv:1.9.2.27) Gecko/20120216 Lightning/1.0b2 Thunderbird/3.1.19 MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Re: Urgent help required References: X-ASG-Orig-Subj: Re: [ADMIN] Urgent help required In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 19 Apr 2012 21:54:52.0009 (UTC) FILETIME=[0C4F7D90:01CD1E77] X-Barracuda-Connect: UNKNOWN[172.16.66.171] X-Barracuda-Start-Time: 1334872492 X-Barracuda-URL: http://10.85.4.6:8000/cgi-mod/mark.cgi X-Virus-Scanned: by bsmtpd at d2.com X-Barracuda-Spam-Score: 0.00 X-Barracuda-Spam-Status: No, SCORE=0.00 using per-user scores of TAG_LEVEL=1000.0 QUARANTINE_LEVEL=1000.0 KILL_LEVEL=9.0 tests= X-Barracuda-Spam-Report: Code version 3.2, rules version 3.2.2.94604 Rule breakdown below pts rule name description ---- ---------------------- -------------------------------------------------- X-Spam-Status: NO, score=-2.6 required=3.0 tests=ALL_TRUSTED,AWL,BAYES_00, RATWARE_GECKO_BUILD autolearn=ham version=3.2.4 X-Spam-Checker-Version: SpamAssassin 3.2.4 (2008-01-01) on mx2.d2.com X-Pg-Spam-Score: -1.9 (-) X-Archive-Number: 201204/110 X-Sequence-Number: 39446 Usually the standard location for data is /var/lib/pgsql/data for postgresql 8. So try to restore this directory first and underneath. Only with that you can hopefully restore the whole system assuming that if tablespaces were creates are under the standard location. I would ask others to make sure there are no backups, sometimes there is guy who knows... Good luck A.A. On 04/19/2012 10:47 AM, Nagaraj Shindagi wrote: > Hi team, > > i am nagaraj, i am newbi in this database world. i required your help. > 2 dyas back i formatted one of my client system. which is having > postgresql 8.2 database & that was having data. but i am not taken > backup of the data. > 1) how to take the data from the formatted harddisk. ? > 2) how many folders or files will be their at base folder. When we > install postgresql 8.2? > 3) how to identify which folder contain which file. ? > > Please help it is very urgent. > thanks and regards > > > -- > Nagaraj V Shindagi