Re: Unable to start postgresql-14

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.
I restore from backup and it couldn't start.

I ended up doing a pg_resetwal to start it and ended up with lots of data
corruption.

I have try a pg_dumpall to restore in a new server and it has equally
failed.

On Sat, Dec 23, 2023 at 11:35 AM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 12/22/23 22:48, Johnathan Tiamoh wrote:
> > Hello,
> >
> > I am able to start postgresql because of the below error. Please is
> > there any help
> >
> > User
> > You
> > FATAL: xlog flush request 4392/164662F8 is not satisfied --- flushed
> > only to 4392/F000058
> >
> >
> > UserYouFATAL: xlog flush request 4392/164662F8 is not satisfied ---
> > flushed only to 4392/F000058
> >
>
> More information needed:
>
> 1) Exact Postgres version e.g 14.x
>
> 2) Is it community version or fork?
>
> 3) What was the command you used to start the cluster?
>
> 4) Do you have replication/WAL archiving set up?
>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>
>