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 ?
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
Hello Laurenz,
Thank you very much for your reply.
On Fri, Dec 22, 2023 at 7:10 AM Laurenz Albe <laurenz.albe@cybertec.at>
wrote:
Show quoted text
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