PG connection gets lost

[Sten-Erik Björling]

Very good information!!

Thanks!

Stene

______

> 30 juni 2020 kl. 05:13 skrev Doug Easterbrook <doug at artsman.com>:
> 
> hi Mike.
> 
> Like Bas says, most likely a machine going to sleep.
> 
> 
> here is a general list of things that we do to Mac’s (especially postgres servers) to make sure things are cool.  Some are because of Postgres, some are because of omnis.   
> 
> MacOS is notorious for trying to save energy — which really isn’t a good idea for a server.  
> 
> 
> https://help.theatremanager.com/installing-theatre-manager/server-power-saving-settings
> 
> 
> you might also want to update to latest postgres 11.8 
> 
> 
> 
> 
> Doug Easterbrook
> Arts Management Systems Ltd.
> mailto:doug at artsman.com
> http://www.artsman.com
> Phone (403) 650-1978
> 
>> On June 29, 2020, at 6:35 PM, Mike Rowan <michael.rowan3 at gmail.com> wrote:
>> 
>> Morning all
>> 
>> I am in the process of testing a new Mac Mini running 10.14.6 as a "server"
>> to provide PostgreSQL 11.4 to my local network.  All works very well.
>> 
>> Except that some mornings, after it and a workstation have been left
>> running overnight (as usual) and Omnis Studio had a connection open last
>> evening, the connection is lost.  pgAdmin 4.21 had been left running.
>> 
>> Looking at the log I see:
>> WARNING:  terminating connection because of crash of another server process
>> DETAIL:  The postmaster has commanded this server process to roll back the
>> current transaction and exit, because another server process exited
>> abnormally and possibly corrupted shared memory.
>> HINT:  In a moment you should be able to reconnect to the database and
>> repeat your command.
>> 
>> I have not seen this on an earlier equipment, and wonder if there are any
>> clues as to what might be going on? pgAdmin4 the "other server process"
>> here?
>> 
>> I've put in an automatic recovery process, but would like to know what's
>> what.  Thanks for any  hints.
>> _____________________________________________________________
>> Manage your list subscriptions at http://lists.omnis-dev.com
>> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com 
> 
> _____________________________________________________________
> Manage your list subscriptions at http://lists.omnis-dev.com
> Start a new message -> mailto:omnisdev-en at lists.omnis-dev.com