Was this backup taken before the data directory was deleted? Yes. I restored it from a 1-day old backup, but unfortunately, I couldn't apply the logs.
If so how was the backup done? It was taken with a customized script that uses pg_dump. Does this mean you recreated the data directory from some source and then ran pg_resetwal? I recreated it from the backup Do you mean you did a pg_dumpall from the Postgres instance running on the restored data directory? Yes. And it failed On Sat, Dec 23, 2023 at 5:35 PM Adrian Klaver <adrian.kla...@aklaver.com> wrote: > On 12/23/23 10:05, Johnathan Tiamoh wrote: > > More information needed: > > > > 1) Exact Postgres version e.g 14.x > > > > Postgresql Version 14. 10 > > > > 2) Is it community version or fork? > > > > Community version > > > > 3) What was the command you used to start the cluster? > > > > systemctl start postgresql-14 > > > > 4) Do you have replication/WAL archiving set up? > > > > Yes. > > > > > > Just to add. The data directory was accidentally deleted. At the time of > > deletion. The secondary was broken. > > So that is the cause of the issue. > > > I restore from backup and it couldn't start. > > Was this backup taken before the data directory was deleted? > > If so how was the backup done? > > > > > I ended up doing a pg_resetwal to start it and ended up with lots of > > data corruption. > > Does this mean you recreated the data directory from some source and > then ran pg_resetwal? > > > > > I have try a pg_dumpall to restore in a new server and it has equally > > failed. > > Do you mean you did a pg_dumpall from the Postgres instance running on > the restored data directory? > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > >
