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.