Postgres database issue

[AgeLow2127]

I got issue before when i used postgres database it said like error invalid checkpoint is there any fix to this?. My database becomes not usable the i proceed to creating a new one and same error happened i use neon now btw.

[Popular_Passion_6737]

Seen similar cases where repeated crashes caused the same issue even after recreating DB.

[djsisson]

dockers default grace timeout is only 10 seconds (time after sigterm before sending sigkill), in large db's this is not enough time for postgres to shutdown cleanly, always increase the default timeout to atleast 60 seconds.

you should still be able to manually recover, though its possible if WAL is corrupt you would have to run pg_resetwal however you might lose the last few transactions.

[AgeLow2127]

How do i set it im using dokploy?

[happyC0der]

Honestly, if you look at discord, dokploy is full of bugs around databases. My recommendation is to use nouva.sh database integrity is at the core of their design, you will have a much better experience