Re: Unable to start postgresql-14

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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
>
>