Re: postgres on physical replica crashes

2018-05-07 Thread SRINIVASARAO OGURI
Hi Greig Wise, If you are using CentOS/REDHAT - 07 , check this link " https://srinivasoguri.blogspot.in/2018/04/postgresql-crash-in-centosredhat-07.html " On Fri, Apr 20, 2018 at 6:58 PM, Hannes Erven wrote: > Hi Greig, > > > just last week I experienced the same situation as you on a 10.3 phy

Re: postgres on physical replica crashes

2018-04-20 Thread Hannes Erven
Hi Greig, just last week I experienced the same situation as you on a 10.3 physical replica (it even has checksums activated), and a few months ago on 9.6 . We used the same resolution as you we, and so far we haven't noticed any problems with data integrity on the replicas. The logs were

postgres on physical replica crashes

2018-04-18 Thread greigwise
Hello. I've had several instances where postgres on my physical replica under version 9.6.6 is crashing with messages like the following in the logs: 2018-04-18 05:43:26 UTC dbname 5acf5e4a.6918 dbuser DETAIL: The postmaster has commanded this server process to roll back the current transaction