| From: | Jan Wieck <jan(at)wi3ck(dot)info> |
|---|---|
| To: | Michael Paquier <michael(at)paquier(dot)xyz> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andres Freund <andres(at)anarazel(dot)de>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, Alexander Shutyaev <shutyaev(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_upgrade and wraparound |
| Date: | 2021-03-13 13:43:54 |
| Message-ID: | e15fe338-c389-0571-7616-233170f2a30a@wi3ck.info |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 3/12/21 8:30 PM, Michael Paquier wrote:
> Hi Jan,
>
> On Fri, Mar 12, 2021 at 06:13:33PM -0500, Jan Wieck wrote:
>> One of the things in my way is that when using pg_resetwal to put the
>> NextXID way into the future (to push the old cluster close to wraparound for
>> example), the postmaster won't start because it doesn't have the pg_xact
>> files for that around. Should pg_resetwal create the files in the gap
>> between the old NextXID and the new one?
>
> I think that you should add this patch to the next commit fest to
> track it properly:
> https://commitfest.postgresql.org/33/
> --
> Michael
>
Actually this is the wrong patch (this one is for PG-12, not for HEAD).
Will update later today.
But yes, putting it into the next commitfest after initial discussion is
the plan.
Regards, Jan
--
Jan Wieck
Principle Database Engineer
Amazon Web Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Julien Rouhaud | 2021-03-13 13:45:52 | Re: How to recover data from 9.3 data directory |
| Previous Message | Andrus | 2021-03-13 13:28:37 | How to recover data from 9.3 data directory |