Re: Issue in PG start

On 5/7/21 10:14 PM, 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.

First why switch the computer off for lunch?

Second did you stop the Postgres server before shutting down the machine?

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


In postgresql.conf what is log_min_messages set to?

See here:

https://www.postgresql.org/docs/11/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHEN

Table 19.2. Message Severity Levels

for more information on what the levels represent.

Do you have replication set up with this server?

> 
> 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
> 2021-05-08 10:28:36.159 IST [7048] FATAL:  the database system is 
> starting up

> Happiness Always
> BKR Sivaprakash
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com