PostgreSQL 14 standby recovery stuck in archive recovery state

From: Vijay Raut <vjraaut(at)gmail(dot)com>
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: PostgreSQL 14 standby recovery stuck in archive recovery state
Date: 2026-08-07 19:25:27
Message-ID: CAJkrksppRKi+M-fGhTCROWZim6L33ZVJeagmbbtY3tVYKqrusg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello PostgreSQL Community,

We are facing an issue with a PostgreSQL 14 standby/replica instance where
recovery appears to be stuck and the database is not becoming available for
read connections.
Environment

-

PostgreSQL Version: 14.23
-

OS: Ubuntu 22.04
-

Architecture: x86_64
-

Deployment: Streaming replication standby
-

Data directory:

/data/pgdata_14

Issue Description

The replica started recovery after an interruption. PostgreSQL logs show:

LOG: database system was interrupted while in recovery at log time
2026-08-06 05:26:34 IST
LOG: entering standby mode
LOG: redo starts at 13B9/6D355F08

Recovery starts successfully, but the instance remains in recovery and does
not reach a consistent state where connections are accepted.

Connection attempts fail with:

FATAL: the database system is not yet accepting connections
DETAIL: Consistent recovery state has not been yet reached.

The startup process continues to replay WAL records, but progress appears
to stop.
PostgreSQL pg_controldata output

pg_control version number: 1300
Catalog version number: 202107181
Database system identifier: 7479073413122508773

Database cluster state: in archive recovery

pg_control last modified: Fri 07 Aug 2026 11:50:35 PM IST

Latest checkpoint location: 13B9/73735BC8
Latest checkpoint's REDO location: 13B9/6D355F08
Latest checkpoint's REDO WAL file: 0000000F000013B90000006D

Latest checkpoint's TimeLineID: 15
Latest checkpoint's PrevTimelineID: 15

Minimum recovery ending location: 13BA/10996458
Min recovery ending loc's timeline: 15

Backup start location: 13AC/C59613E8
Backup end location: 0/0
End-of-backup record required: yes

wal_level setting: replica
wal_log_hints setting: on

max_connections: 2000
max_worker_processes: 16
max_wal_senders: 10

Data page checksum version: 0

Additional observations

The PostgreSQL log contains many WAL redo messages similar to:

DEBUG: WAL redo at 13B9/...

The startup process is active, but recovery does not complete.

We checked storage-related issues:

-

/data filesystem is healthy from space perspective.
-

PostgreSQL data directory is on:

/dev/mapper/VG01-data_lv

-

No clear filesystem I/O errors were observed.
-

Kernel logs showed previous DISCARD/TRIM related messages:

blk_update_request: critical target error, dev sdb, sector xxxx op 0x3:(DISCARD)

but no confirmed read/write I/O failures.
Checks performed

1.

PostgreSQL process status:

ps -ef | grep postgres

Questions

1.

What could prevent PostgreSQL 14 standby recovery from reaching a
consistent recovery state when WAL replay appears active?
2.

Is there a way to identify which WAL record or relation is preventing
recovery completion?

Any guidance on further troubleshooting would be appreciated.

Regards,
Vijay R

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Laurenz Albe 2026-08-07 21:56:00 Re: Urgent !!!! Tables inaccessible postgres v17.6
Previous Message mahamood hussain 2026-08-06 15:42:24 Re: Urgent !!!! Tables inaccessible postgres v17.6