Postgres is going to sleep or something...

Das Goravani goravanis at gmail.com
Wed Feb 2 21:49:13 UTC 2022



> On Feb 2, 2022, at 3:57 PM, Doug Easterbrook via omnisdev-en <omnisdev-en at lists.omnis-dev.com> wrote:
> 
> yup.    
> 
> thats why getting into the logs should help.     if you are seeing a memopry excepton or crash of postgres ( check the console log)…
> 
> then maybe, just maybe, it indicating of hardware issue, or some bad actor application, or that somebody has changed permissions on the file
> 
> 
> remember
> 
> su - postres
> cd /Library/Postgresql/14//Data/Logs

I can get to the postgres user, but there is no such directory as /Library/Postgresql/14/Data/Logs
> 
> 
> ls -la

Is that LS and LA? In lowercase?
Is that a command you type in after you have CD’d correctly?
> 
> get a listing of the logs
> 
> use nano or vi or vim (as you wish) to edit a log and see whats at the end.

I know how to use NANO

> 
> 
> 
> Doug Easterbrook
> Arts Management Systems Ltd.
> mailto:doug at artsman.com
> http://www.artsman.com
> Phone (403) 650-1978
> 
>> On February 2, 2022, at 12:37 PM, TBS <andyh at totallybrilliant.com> wrote:
>> 
>> I have to agree with Doug - Postgres has always been *the* most reliable engine going - I have never seen any of our instances stop of their own accord ever…….there will be something else at play here for sure
>> 
>> Andy Hilton
>> Totally Brilliant Software Inc
>> Phone (US) : (863) 409 4870
>> Phone (UK) : 0207 193 8582
>> Web : www.totallybrilliant.com
>> Helpdesk : http://totallybrilliant.kayako.com
>> Email : andyh at totallybrilliant.com
>> On Feb 2, 2022, 3:29 PM -0500, Doug Easterbrook via omnisdev-en <omnisdev-en at lists.omnis-dev.com>, wrote:
>>> das.
>>> 
>>> I’ve never seen Postgres shut down the server by itself. All of our hundreds of installs run constantly, 24 hrs per day, on every server we have ever installed it on, mac, windows, linux, freenas. Postgres only stops when you make it stop, never by itself unless it abends
>>> 
>>> which brings us back to the postgres logs. /Library/Postgres/14/data/logs
>>> 
>>> go and look at those.
>>> 
>>> if there are multiple log files per day, it likely means postgres restarted (for some reason)
>>> 
>>> then edit the log file and look at the end of it…. and see what it says.
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> 
>>> Doug Easterbrook
>>> Arts Management Systems Ltd.
>>> mailto:doug at artsman.com
>>> http://www.artsman.com
>>> Phone (403) 650-1978
>>> 
>>>> On February 2, 2022, at 12:14 PM, Das Goravani <goravanis at gmail.com> wrote:
>>>> 
>>>> Doug, I appreciate your long post about sleep in general, but...
>>>> 
>>>> It just happened so I took the opportunity to check all things.
>>>> 
>>>> I was connected to postgres on my MBP which is remote to the server. I had a SESSION showing under the SQL Browser in Omnis.
>>>> 
>>>> I then expanded the SQL Browser to see Tables within that session. There were none. There should be 1 there.
>>>> 
>>>> I figured my connection was dropped, or that "postgres went to sleep"
>>>> 
>>>> I tried to log on and got the watch on the logon command line in Omnis
>>>> 
>>>> I then switched to the server, tried to log Omnis in there. No go, got the watch. That now being a localhost connection attempt.
>>>> 
>>>> I then switched to pgAdmin on the server. I launched it. When in it I click on Servers and enter my password, I get the message that the connection attempt failed
>>>> 
>>>> If I then start postgres using Terminal
>>>> 
>>>> pgAdmin then connects just fine
>>>> 
>>>> And I can log Omnis in on both computers
>>>> 
>>>> And my one table shows in the SQL Browser in Omnis
>>>> 
>>>> It is really as if postgres is shutting down on the server all by itself
>>>> 
>>>> ???
>>>> _____________________________________________________________
>>>> Manage your list subscriptions at https://lists.omnis-dev.com
>>>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
>>> 
>>> _____________________________________________________________
>>> Manage your list subscriptions at https://lists.omnis-dev.com
>>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com
>> _____________________________________________________________
>> Manage your list subscriptions at https://lists.omnis-dev.com
>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 
> 
> _____________________________________________________________
> Manage your list subscriptions at https://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 



More information about the omnisdev-en mailing list