Re: Issue in PG start

On 5/8/21 9:23 AM, Ron wrote:
> On 5/8/21 10:53 AM, Adrian Klaver wrote:
>> 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?
> 
> If it's a desktop and he's a developer, then that's reasonable.
> 
>>
>> Second did you stop the Postgres server before shutting down the machine?
> 
> Is Windows Postgresql a service?  If so then Windows "should" shut it 
> down cleanly when you cleanly power off the machine.
> 

The log would indicate otherwise:

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

So something is not working as it should.


-- 
Adrian Klaver
adrian.klaver@aklaver.com