Postgres Pro
Downloads
Home   >   mailing lists

what do you do after pg_walreset ? - Mailing list pgsql-general

From Johnathan Tiamoh
Subject what do you do after pg_walreset ?
Date
Msg-id CACoPQdYKGdAbyC9qdXv4tK5+4CAUbXmSqBnRuZnmO8wP=x_RFg@mail.gmail.com
Whole thread Raw
Responses Re: what do you do after pg_walreset ?  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-general
Tree view
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 ?


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Changing a schema's name with function1 calling function2
Next
From: Kouber Saparev
Date:
Subject: Logical replication breaks: "unexpected duplicate for tablespace 0, relfilenode 2774069304"