Re: Issue in PG start

On 5/8/21 9:19 PM, sivapostgres(at)yahoo(dot)com wrote:
> 1. First why switch the computer off for lunch?
>         It's a development machine and I'm a developer.   We used to shut
> down every computer for lunch.  We shut down the windows and not just hit
> the power switch.   We advice and follow every users and client to shut
> down the windows properly and we follow it.
>
> 2. In postgresql.conf what is log_min_messages set to?
>         Warning
>
> 3. Do you have replication set up with this server?
>         No
>
> 4.   Is Windows Postgresql a service?  If so then Windows "should" shut it
> down cleanly when you cleanly power off the
>         machine.
>         Yes, Postgresql is a service and windows is shut down properly.   
> We do shut down computers during lunch and when closing office, regularly
> and properly for the past 6 months [ since PG was installed ] without any
> issue.   This is the first time that we face this issue.
>
> Need to find a solution that will be helpful if that happens in a
> production machine.

I suggest that you manually stop postgresql before shutting down your PC. 
If that solves the problem, then you've discovered that there's a problem in
how the service stops Postgresql.

pg_ctl stop -D X:\path\to\data -mfast

--
Angular momentum makes the world go 'round.