From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | "sivapostgres(at)yahoo(dot)com" <sivapostgres(at)yahoo(dot)com>, Pgsql-general General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Issue in PG start |
Date: | 2021-05-08 15:53:30 |
Message-ID: | 6f2176a2-b48c-7992-8c53-c740fee40a11@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 5/7/21 10:14 PM, sivapostgres(at)yahoo(dot)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?
Second did you stop the Postgres server before shutting down the machine?
>
> But today morning [08th May], again we have the same issue and same
> message. The log file is with the following message only
In postgresql.conf what is log_min_messages set to?
See here:
https://www.postgresql.org/docs/11/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHEN
Table 19.2. Message Severity Levels
for more information on what the levels represent.
Do you have replication set up with this server?
>
> 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
> 2021-05-08 10:28:36.159 IST [7048] FATAL: the database system is
> starting up
> Happiness Always
> BKR Sivaprakash
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Ron | 2021-05-08 16:23:56 | Re: Issue in PG start |
Previous Message | Avinash Kumar | 2021-05-08 12:28:36 | Re: idle_in_transaction_session_timeout |