Re: Issue in PG start

["sivapostgres@xxxxxxxxx" <sivapostgres@xxxxxxxxx>]

The above is the contents of the log file from 'data' folder of PG.   

Message in Windows Application Event

2021-05-08 10:26:19.425 IST [5588] LOG:  listening on IPv4 address "0.0.0.0", port 5433

On Saturday, 8 May, 2021, 11:02:06 am IST, David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Friday, May 7, 2021, sivapostgres@xxxxxxxxx <sivapostgres@xxxxxxxxx> wrote:

Hello,

PG 11.8 in Windows 10 and currently PG 11.11

Yesterday [07th May] morning when we switched on the computer and subsequently PGAdmin, we got the message following message

FATAL: the database system is starting up

I uninstalled PG and installed [v 11.11] PG with the same data directory.  Fortunately it worked even when we switched off /on the computer for lunch.   NO issues yesterday.

But today morning [08th May], again we have the same issue and same message.   The log file is with the following message only

2021-05-08 10:26:20.783 IST [7360] LOG:  database system was interrupted; last known up at 2021-05-07 18:46:00 IST

How / where to debug the issue and correct it ?

To see why the server is not completing its startup cycle you need to look at the server’s log file.  All you’ve shown is a client failing to establish a connection every ten seconds.

David J.