From: | Andres Freund <andres(at)anarazel(dot)de> |
---|---|
To: | Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com>,Robert Haas <robertmhaas(at)gmail(dot)com> |
Cc: | "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: "using previous checkpoint record at" maybe not the greatest idea? |
Date: | 2016-02-05 00:31:59 |
Message-ID: | A18710D8-B3D6-486D-9286-B826EBF8B1AB@anarazel.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On February 5, 2016 2:52:20 AM GMT+03:00, Jim Nasby <Jim(dot)Nasby(at)BlueTreble(dot)com> wrote:
>On 2/4/16 3:37 PM, Andres Freund wrote:
>> On 2016-02-03 09:28:24 -0500, Robert Haas wrote:
>>> Would we still have some way of forcing the older checkpoint record
>to
>>> be used if somebody wants to try to do that?
>>
>> I think currently the best way to force an arbitrary checkpoint to be
>> used is creating a "custom" backup label. Not that nice. Not sure if
>we
>> need something nice here, I don't really see a frequent need for
>this.
>>
>> We could add another option to pg_resetxlog alternatively :/
>
>I guess you'd have to scan through WAL files by hand to find the next
>oldest checkpoint?
Just look at pg control, it contains the precious location?
---
Please excuse brevity and formatting - I am writing this on my mobile phone.
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2016-02-05 01:35:42 | Re: proposal: multiple psql option -c |
Previous Message | Jim Nasby | 2016-02-05 00:21:51 | Re: Batch update of indexes |