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 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 >
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
what do you do after pg_walreset ?
Hello, Please I wish to find out what you do after running pg_walreset. 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. 1, I wish to find out what to do after i have started postgresql ? 2, How do I apply the wall files after the reset ? 3, How can I determine the amount of data lost ?