Re: recovery long after startup - Mailing list pgsql-general

From Tom Lane
Subject Re: recovery long after startup
Date
Msg-id 286098.1680208930@sss.pgh.pa.us
Whole thread Raw
In response to recovery long after startup  (Rébeli-Szabó Tamás <pub@rblst.info>)
List pgsql-general
=?utf-8?Q?R=C3=A9beli-Szab=C3=B3_Tam=C3=A1s?= <pub@rblst.info> writes:
> I have noticed that a PostgreSQL 13 server went into recovery mode for 2
> seconds during normal operation, not at startup, preventing users from
> connecting.

The most obvious explanation is that a backend (or other postmaster
child process) crashed.  I lack an explanation of why your log
trace doesn't show anything about that, but that seems like an
idea to pursue.  What is the logging mechanism you're using?

            regards, tom lane



pgsql-general by date:

Previous
From: Rébeli-Szabó Tamás
Date:
Subject: recovery long after startup
Next
From: Siddharth Jain
Date:
Subject: Question on creating keys on partitioned tables