On 5/8/21 9:19 PM, sivapostg...@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.
