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

From Ron
Subject Re: Issue in PG start
Date
Msg-id d6882bec-6c3b-36e5-659a-c1662c4fc030@gmail.com
Whole thread Raw
In response to Re: Issue in PG start  ("sivapostgres@yahoo.com" <sivapostgres@yahoo.com>)
List pgsql-general
On 5/8/21 9:19 PM, sivapostgres@yahoo.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.

pgsql-general by date:

Previous
From: "sivapostgres@yahoo.com"
Date:
Subject: Re: Issue in PG start
Next
From: Adrian Klaver
Date:
Subject: Re: Issue in PG start