| From: | loganathan P <plogandba(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Cc: | loganathan P <plogandba(at)gmail(dot)com> |
| Subject: | PostgreSQL Service Unable to Start After Archive Log delete |
| Date: | 2026-09-10 12:58:49 |
| Message-ID: | CAFX4Q9+z686bXOLuxd1pQ7nLCPVFAhLJwVy7qDbtQA5y8i+D8g@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Dear All,
Unfortunately, the OS housekeeping activity has been performed, and all
archive log files has been deleted from both the archive log and pg_wal
locations. We attempted to start the service, but it is unable to start due
to the error shown below. Please provide the solution.
starting PostgreSQL 15.18 on x86_64-pc-linux-gun, compiled by gcc (GCC)
8.5.0 20210514 (Red Hat 8.5.0-28), 64-bit
listening on IPv4 address "192.168.56.15", port 5423
listening on Unix socket "var/run/postgresql/.s.PGSQL.5423"
listening on Unix socket "/tmp/ .s.PGSQL.5423"
database system was shut down in recovery at 2026-09-10 11:10:40 IST
invalid primary checkpoint record
PANIC: could not locate a valid checkpoint record
startup process (PID 1031317) was terminated by signal 6: Aborted
terminating any other active sever processes
shutting down due to startup process failure
database system is shut down
Thanks.
Regards,
Loganathan P
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2026-09-10 13:53:15 | Re: PostgreSQL Service Unable to Start After Archive Log delete |
| Previous Message | Laurenz Albe | 2026-09-10 11:54:36 | Re: What is the cost of a tx? |