X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 9ED5ED1B1BC for ; Tue, 15 Jun 2004 13:37:09 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 65476-09 for ; Tue, 15 Jun 2004 16:37:01 +0000 (GMT) Received: from trade-india.com (infocom01.trade-india.com [67.18.55.68]) by svr1.postgresql.org (Postfix) with SMTP id 7AAC8D1B19B for ; Tue, 15 Jun 2004 13:36:59 -0300 (ADT) Received: (qmail 1301 invoked by uid 99); 15 Jun 2004 11:08:00 -0000 Received: from 61.16.154.82 (SquirrelMail authenticated user mallah) by mail.trade-india.com with HTTP; Tue, 15 Jun 2004 16:38:00 +0530 (IST) Message-ID: <57920.61.16.154.82.1087297680.squirrel@mail.trade-india.com> Date: Tue, 15 Jun 2004 16:38:00 +0530 (IST) Subject: Re: pg_xlog folder lost ! From: To: X-Priority: 3 Importance: Normal X-MSMail-Priority: Normal Cc: X-Mailer: SquirrelMail (version 1.2.6) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=CLICK_BELOW, NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200406/176 X-Sequence-Number: 13836 > Rajesh Kumar Mallah wrote: >> >> Hi, >> >> The harddrive on which i had linked pg_xlog >> has been lost. I have all other folders except that >> which are in a seperate drive are present. >> >> Can i get my data back using pg_resetxlog ? > > Give it a try: create the xlog folder again and run pg_resetxlog. Thanks. My hosting company is yet to bring the machine up. I have tried this process in my local machine and it works. I think this process only gets the data till last checkpoint reliably . I hope its correct. Regds Mallah > > Regards, > Bjoern ----------------------------------------- Over 1,00,000 exporters are waiting for your order! Click below to get in touch with leading Indian exporters listed in the premier trade directory Exporters Yellow Pages. http://www.trade-india.com/dyn/gdh/eyp/