Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VOcxG-0007Ln-RJ for pgsql-admin@arkaria.postgresql.org; Wed, 25 Sep 2013 00:27:47 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1VOcxG-0007U9-3j for pgsql-admin@arkaria.postgresql.org; Wed, 25 Sep 2013 00:27:46 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VOcxE-0007U1-Ro for pgsql-admin@postgresql.org; Wed, 25 Sep 2013 00:27:45 +0000 Received: from nm18-vm0.bullet.mail.bf1.yahoo.com ([98.139.213.138]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1VOcxB-0007mI-DJ for pgsql-admin@postgresql.org; Wed, 25 Sep 2013 00:27:43 +0000 Received: from [98.139.212.151] by nm18.bullet.mail.bf1.yahoo.com with NNFMP; 25 Sep 2013 00:27:40 -0000 Received: from [98.139.212.246] by tm8.bullet.mail.bf1.yahoo.com with NNFMP; 25 Sep 2013 00:27:40 -0000 Received: from [127.0.0.1] by omp1055.mail.bf1.yahoo.com with NNFMP; 25 Sep 2013 00:27:40 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 424315.23404.bm@omp1055.mail.bf1.yahoo.com Received: (qmail 59153 invoked by uid 60001); 25 Sep 2013 00:27:39 -0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1380068859; bh=Hl0JNx+nfbrFlxaaRse3x7mph6+vGwTf14EQigOmx04=; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=jVueRNSOPx47yUGtMwtwxII8Y4ep6l7FIqNFuJviHN6JVTOsvMRCM6VnoXo3DdnBchOLhiGNfJueCzML29gyVrIMwvwfKTowQEpq/XyS+nenZUbfs6jtvu4n+YnYxnniiChou9AYixqETxRhj/sHGu2JNtZgWt7W0upd76PDPkU= DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=X-YMail-OSG:Received:X-Rocket-MIMEInfo:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type; b=4ERjkcWQjNBed2kU4/8RsCTqhBzx/N0Ph17Qq2OT6EUrF5m/mMl1VpK9TfNBLed2SXZfFz3cbF2cDYtujX8W9aQ/E4T1Ch0oBCIy1V2WpW6IMvYjAtCT65N3AxlRJasYtP/IR1P23WQty/r7OsC0WS9S+fQo/Z35AAKhDEROZJ0=; X-YMail-OSG: _IR1OTMVM1mV8QYV4jsOHVvo43_PUbcDgTtv9dvjTwrj5JK ekPdsRMCSQ5WaaPQi1biL65rK5RU1F7.VFpuZ1UE6X3vM7fYWQSFnKbSqdoh CyCn0vkjWA.Kx.W2YDDGYitGCA0CdnBdNCZTlW6zRD7Ml.irHdvJUECq_oa_ UM8HQMyBig4aoO0pL2tfER9l7uxQv0HxErMVoMOC8LA.YhiDkoqhrODGSyFH EPpZkiMzXs4dhc2uRTdNhUS7xJ0Il_BPdzUxBL.d_wwVzT5UJudTmKi2vMk2 vDHee4pUJ3YxViw5Xg_bMu._JC_VLwg7L2fRXG0zUZ1eVFakRVhNBcKhSHiz f6afe57ZbZWUDJ3Y112RxHdfNq77Ha4TpF56BKHiUU.XZd2pg.bgg5vTusc2 Amcr4VhtwKfNpjf18KJl.MdUGx9Kl1jEeQXoaRDSVMzO59XuOrlC8MeKmt.A fvsFN2rgyT8cCmM1wObpJsenmp4G7b_NiuBPulfIy7U4OTCBHPwtjZhw0_IS Ac.wLMtYTo.txsd.S56Amitz3jWDbfBU.AthyxibMit8Laxl5AKzbvZ9MPK6 g0rt2dEe1lHn1rrFWY9y8OK8ot2gdWGIPB2Yj Received: from [50.241.80.25] by web125005.mail.ne1.yahoo.com via HTTP; Tue, 24 Sep 2013 17:27:39 PDT X-Rocket-MIMEInfo: 002.001, VGhhbmsgeW91IQrCoApJIGRlbGV0ZWQgZGF0YSBkaXJlY3RvcnkgYWdhaW4gYW5kIHRoZW4gcmFuIGluaXRkYi4KVGhpcyB0aW1lIHNlcnZpY2Ugc3RhcnRlZCBzdWNjZXNzZnVsbHkuClRHCsKgCgoKX19fX19fX19fX19fX19fX19fX19fX19fX19fX19fX18KRnJvbTogQWxiZSBMYXVyZW56IDxsYXVyZW56LmFsYmVAd2llbi5ndi5hdD4KVG86IFRoYXJhIFZhZGFra2V2ZWVkdSA8dGhhcmFndkB5YWhvby5jb20.OyAicGdzcWwtYWRtaW5AcG9zdGdyZXNxbC5vcmciIDxwZ3NxbC1hZG1pbkBwb3N0Z3Jlc3FsLm8BMAEBAQE- X-Mailer: YahooMailWebService/0.8.157.561 References: <48F1E182B1021B449414C85E713CE8250E61E0@WLT-MBX03.KRONOS.com> <1379975782.27726.YahooMailNeo@web125005.mail.ne1.yahoo.com> <1380030420.19939.YahooMailNeo@web125003.mail.ne1.yahoo.com> <1380030784.27416.YahooMailNeo@web125003.mail.ne1.yahoo.com> <1380031785.83405.YahooMailNeo@web125005.mail.ne1.yahoo.com> Message-ID: <1380068859.48649.YahooMailNeo@web125005.mail.ne1.yahoo.com> Date: Tue, 24 Sep 2013 17:27:39 -0700 (PDT) From: Thara Vadakkeveedu Reply-To: Thara Vadakkeveedu Subject: Re: accidentally deleted data directory To: Albe Laurenz , "pgsql-admin@postgresql.org" In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="1988236031-1205453899-1380068859=:48649" X-Pg-Spam-Score: -1.6 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --1988236031-1205453899-1380068859=:48649 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable Thank you!=0A=A0=0AI deleted data directory again and then ran initdb.=0ATh= is time service started successfully.=0ATG=0A=A0=0A=0A=0A__________________= ______________=0AFrom: Albe Laurenz =0ATo: Thara V= adakkeveedu ; "pgsql-admin@postgresql.org" =0ASent: Tuesday, September 24, 2013 10:11 AM=0ASubject: Re= : [ADMIN] accidentally deleted data directory=0A=0A=0AThara Vadakkeveedu wr= ote:=0A> Do I need to run pg_resetxlog to fix the corrupted pg_control file= issue?=0A=0ANo, since you don't mind starting afresh,=0Ajust delete the da= ta directory and run initdb.=0A=0AYours,=0ALaurenz Albe=0A=0A-- =0ASent via= pgsql-admin mailing list (pgsql-admin@postgresql.org)=0ATo make changes to= your subscription:=0Ahttp://www.postgresql.org/mailpref/pgsql-admin --1988236031-1205453899-1380068859=:48649 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: quoted-printable
Thank you!
 
I deleted data directory again and then= ran initdb.
This time service st= arted successfully.
TG
 

From: Albe Laurenz <laurenz.albe@wien.= gv.at>
To: Thara Vada= kkeveedu <tharagv@yahoo.com>; "pgsql-admin@postgresql.org" <pgsql-= admin@postgresql.org>
Sent: Tuesday, September 24, 2013 10:11 AM
Subject: Re: [ADMIN] accidentally deleted data directo= ry

Thara Vadakkeveedu wrote:
> Do I nee= d to run pg_resetxlog to fix the corrupted pg_control file issue?

No= , since you don't mind starting afresh,
just delete the data directory a= nd run initdb.

Yours,
Laurenz Albe

--
Sent via pgsql-a= dmin mailing list (pgsql-admin@postgresql.org)
To m= ake changes to your subscription:
http://www.postgresql.org/mailpref/pgs= ql-admin


--1988236031-1205453899-1380068859=:48649--