Bug reference: 18088 Logged by: Root Cause Email address: rootcause000@gmail.com PostgreSQL version: Unsupported/Unknown Operating system: Microsoft Windows Server 2019 Standard Description:
Please advise if there are alternative methods to recover the data and if there are options to prevent this issue from occurring even in the event of an abrupt server shutdown.
There is likely no bug here - improper configuration or bad hardware is about the only time an improper shutdown is going to cause data loss. The WAL-based recovery system (which is also usable/required for backups) accommodates abrupt server shutdowns just fine.
Please use the -general or -admin lists if you wish to further discuss how to inspect just how your system may be misconfigured and for any guidance on correcting your lack of backups.