Re: Database system was interrupted. Possible reasons for a database to suddenly stop accepting connections?

On 11/9/20 5:53 AM, Buzenets, Yuriy (GE Renewable Energy, consultant) wrote:
> Some time ago the database at my work suddenly stopped accepting 
> connections. In the logs there was a message “the database system was 
> interrupted; last known up at 2020-10-29 12:03:16 PDT”, followed by a 
> lot of “the database system is starting up” messages. It seems like the 
> database tried to recover from whatever failure occurred but recovery 
> was not successful until the database process was shut down and 
> restarted. The latest error message before “system was interrupted” 
> occurs 13 minutes before so it’s not clear to us what could cause this 
> issue and why the database process had to be restarted. If anyone could 
> help us understand what might’ve been the cause, we would greatly 
> appreciate it. We’re using PostgreSQL 9.4 on CentOS 6.8, we know it 
> reached EOL and plan to upgrade to a newer version soon. I’ve also 
> attached the log file from the time the database system was unavailable 
> if it helps to figure out the cause of the outage

There are a lot of 'terminating connection due to administrator command' 
lines. How many connections where/are being used to this server?

> 
> Thanks,
> 
> Yuriy Buzenets
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com