Re: Issue in PG start

2021-05-09 Thread Laurenz Albe
On Sat, 2021-05-08 at 05:14 +, sivapostg...@yahoo.com wrote: > 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 You will have to wait until startup is completed. Either y

Re: Issue in PG start

2021-05-09 Thread Adrian Klaver
On 5/8/21 7:32 PM, sivapostg...@yahoo.com wrote: Yesterday's log file.   Till we shut down the windows the message was: 2021-05-08 19:03:32.151 IST [10376] FATAL:  the database system is starting up 2021-05-08 19:03:42.210 IST [7568] FATAL:  the database system is starting up Comments in lin

Re: Issue in PG start

2021-05-08 Thread Ron
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 use

Re: Issue in PG start

2021-05-08 Thread sivapostg...@yahoo.com
Yesterday's log file.   Till we shut down the windows the message was:2021-05-08 19:03:32.151 IST [10376] FATAL:  the database system is starting up2021-05-08 19:03:42.210 IST [7568] FATAL:  the database system is starting up Today morning log file, I tried to start the service [ after setting

Re: Issue in PG start

2021-05-08 Thread sivapostg...@yahoo.com
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

Re: Issue in PG start

2021-05-08 Thread Tom Lane
Adrian Klaver writes: > On 5/8/21 9:23 AM, Ron wrote: >> 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 >>> inter

Re: Issue in PG start

2021-05-08 Thread Adrian Klaver
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 me

Re: Issue in PG start

2021-05-08 Thread Ron
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 syst

Re: Issue in PG start

2021-05-08 Thread Adrian Klaver
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 in

Re: Issue in PG start

2021-05-08 Thread sivapostg...@yahoo.com
Or server’s log file is available elsewhere ?   On Saturday, 8 May, 2021, 01:24:50 pm IST, sivapostg...@yahoo.com wrote: The above is the contents of the log file from 'data' folder of PG.    Message in Windows Application Event2021-05-08 10:26:19.425 IST [5588] LOG:  listening on IPv

Re: Issue in PG start

2021-05-08 Thread sivapostg...@yahoo.com
The above is the contents of the log file from 'data' folder of PG.    Message in Windows Application Event2021-05-08 10:26:19.425 IST [5588] LOG:  listening on IPv4 address "0.0.0.0", port 5433 On Saturday, 8 May, 2021, 11:02:06 am IST, David G. Johnston wrote: On Friday, May 7, 202

Re: Issue in PG start

2021-05-07 Thread David G. Johnston
On Friday, May 7, 2021, 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 unin

Re: Issue in PG start

2021-05-07 Thread sivapostg...@yahoo.com
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 messageFATAL: the database system is starting up I uninstalled PG and installed [v 11.11] PG with the same data directory.  Fo