| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | Haiming Zhang <Haiming(dot)Zhang(at)redflex(dot)com(dot)au> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Postgres fails to start |
| Date: | 2015-04-07 03:04:29 |
| Message-ID: | CAB7nPqTybaTzAG7JMx_1UCfDqeXEydsHBNBFuWcywN9TUr6F-A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Apr 7, 2015 at 10:46 AM, Haiming Zhang
<Haiming(dot)Zhang(at)redflex(dot)com(dot)au> wrote:
> Thank you for replying. The file was there, is that ok to remove the corrupted file to recover postgres? "base/2008723533/2107262657.2"
Be careful here, I would recommend taking a file-level snapshot before
going on and do perhaps-stupid things. As that's a btree right split,
perhaps you could recover your data by ignoring this index...
> Unfortunately, I only have a backup on February. Is there a way I can recover it without losing the recent data?
What is lost is lost. A good backup strategy is essential.
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Haiming Zhang | 2015-04-07 07:05:50 | Re: Postgres fails to start |
| Previous Message | Haiming Zhang | 2015-04-07 01:46:39 | Re: Postgres fails to start |