Re: Issue in PG start - Mailing list pgsql-general

From sivapostgres@yahoo.com
Subject Re: Issue in PG start
Date
Msg-id 1815674480.2182075.1620473607633@mail.yahoo.com
Whole thread Raw
In response to Re: Issue in PG start  ("sivapostgres@yahoo.com" <sivapostgres@yahoo.com>)
List pgsql-general
Or server’s log file is available elsewhere ?  

On Saturday, 8 May, 2021, 01:24:50 pm IST, sivapostgres@yahoo.com <sivapostgres@yahoo.com> wrote:


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@gmail.com> wrote:



On Friday, May 7, 2021, sivapostgres@yahoo.com <sivapostgres@yahoo.com> 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. 

pgsql-general by date:

Previous
From: Vijaykumar Jain
Date:
Subject: Re: idle_in_transaction_session_timeout
Next
From: Avinash Kumar
Date:
Subject: Re: idle_in_transaction_session_timeout