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, sivapostg...@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.kla...@aklaver.com
