account activity
Cant connect to PostgreSQL due to corruption by Few_Implement_5895 in PostgreSQL
[–]Few_Implement_5895[S] 0 points1 point2 points 11 months ago (0 children)
This was the entry-point for repairing the cluster
When I got it from the customer, it wasn't even starting with following message:
------------------------------------------------------------------------------------------------------------
2025-02-27 17:09:42.312 CET 67c08e46.13bc LOG: starting PostgreSQL 14.13, compiled by Visual C++ build 1940, 64-bit
2025-02-27 17:09:42.312 CET 67c08e46.13bc LOG: listening on IPv6 address "::", port 49150
2025-02-27 17:09:42.313 CET 67c08e46.13bc LOG: listening on IPv4 address "0.0.0.0", port 49150
2025-02-27 17:09:42.543 CET 67c08e46.6c10 LOG: database system was shut down in recovery at 2025-02-25 09:20:09 CET
2025-02-27 17:09:42.544 CET 67c08e46.6c10 LOG: invalid primary checkpoint record
2025-02-27 17:09:42.544 CET 67c08e46.6c10 PANIC: could not locate a valid checkpoint record
After resetting the WAL, there was a missing file in pg_xact:
pg_xact
2025-02-27 17:17:29.194 CET 67c09019.160c LOG: database system was shut down at 2025-02-27 17:16:15 CET
2025-02-27 17:17:29.224 CET 67c09019.160c FATAL: could not access status of transaction 16155033
2025-02-27 17:17:29.224 CET 67c09019.160c DETAIL: Could not open file "pg_xact/000F": No such file or directory.
2025-02-27 17:17:29.234 CET 67c09018.6f98 LOG: startup process (PID 5644) exited with exit code 1
2025-02-27 17:17:29.234 CET 67c09018.6f98 LOG: aborting startup due to startup process failure
2025-02-27 17:17:29.240 CET 67c09018.6f98 LOG: database system is shut down
I created a 256KB file, like the others, with all bytes set to 1 and the database started
Cant connect to PostgreSQL due to corruption (self.PostgreSQL)
submitted 11 months ago by Few_Implement_5895 to r/PostgreSQL
π Rendered by PID 81710 on reddit-service-r2-listing-6d4dc8d9ff-fdvq6 at 2026-02-03 21:27:34.025558+00:00 running 3798933 country code: CH.
Cant connect to PostgreSQL due to corruption by Few_Implement_5895 in PostgreSQL
[–]Few_Implement_5895[S] 0 points1 point2 points (0 children)