Re: pg_xlog folder lost ! - Mailing list pgsql-admin

From
Subject Re: pg_xlog folder lost !
Date
Msg-id 57920.61.16.154.82.1087297680.squirrel@mail.trade-india.com
Whole thread Raw
In response to pg_xlog folder lost !  (Rajesh Kumar Mallah <mallah@trade-india.com>)
Responses Re: pg_xlog folder lost !
List pgsql-admin
> 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/



pgsql-admin by date:

Previous
From: Duane Lee - EGOVX
Date:
Subject: Re: table not shown
Next
From: "Lee Wu"
Date:
Subject: Re: table not shown