Re: recovery long after startup

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Rébeli-Szabó Tamás <pub(at)rblst(dot)info>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: recovery long after startup
Date: 2023-03-30 20:42:10
Message-ID: 286098.1680208930@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

=?utf-8?Q?R=C3=A9beli-Szab=C3=B3_Tam=C3=A1s?= <pub(at)rblst(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter Smith 2023-03-30 22:30:43 Re: Support logical replication of DDLs
Previous Message Rébeli-Szabó Tamás 2023-03-30 20:35:04 recovery long after startup