| From: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
|---|---|
| To: | Johnathan Tiamoh <johnathantiamoh(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: what do you do after pg_walreset ? |
| Date: | 2023-12-22 12:10:20 |
| Message-ID: | dad7f74266b2b964c7d587b5ff5859929a46e447.camel@cybertec.at |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lok P | 2023-12-22 13:44:01 | Re: Read write performance check |
| Previous Message | Kouber Saparev | 2023-12-22 08:55:24 | Logical replication breaks: "unexpected duplicate for tablespace 0, relfilenode 2774069304" |