Re: what do you do after pg_walreset ?

Hello Laurenz,

Thank you very much for your reply.

On Fri, Dec 22, 2023 at 7:10 AM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
wrote:

> On Thu, 2023-12-21 at 18:53 -0500, Johnathan Tiamoh wrote:
> > Please I wish to find out what you do after running pg_walreset.
>
> You mean pg_resetwal.
>
> > I made a mistake and deleted my data directory with all its content.
> > I then restore with 1 day old backups, after that i could start
> > unless i did pg_walreset.
>
> Which means that the backup was broken.
>
> > 1, I wish to find out what to do after i have started postgresql ?
>
> pg_dumpall the cluster and restore the result to a new cluster
> to get rod of the data corruption introduced by pg_resetwal.
>
> > 2, How do I apply the wall files after the reset ?
>
> You cannot do that.
>
> > 3, How can I determine the amount of data lost ?
>
> Well, everything from after the "backup".
>
> Yours,
> Laurenz Albe
>