Re: what do you do after pg_walreset ?

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