Re: "Time of latest checkpoint" stays too old on both master and slave

2019-06-30 Thread rihad
On 06/30/2019 09:45 PM, Andrew Gierth wrote: "rihad" == rihad writes: rihad> There's a weird problem, even when the time is initially set by rihad> openntpd it keeps lagging by one second every few seconds: rihad> $ sudo /usr/local/etc/rc.d/openntpd restart What OS is this? I've seen

Re: "Time of latest checkpoint" stays too old on both master and slave

2019-06-30 Thread Andrew Gierth
> "rihad" == rihad writes: rihad> There's a weird problem, even when the time is initially set by rihad> openntpd it keeps lagging by one second every few seconds: rihad> $ sudo /usr/local/etc/rc.d/openntpd restart What OS is this? I've seen this kind of thing with FreeBSD where the ke

Re: Postgresql 12 Beta2 Crashes for any Insert/Update

2019-06-30 Thread Mohsen Bande
After Investigating deeper, I found the root cause. Actually, the problem exists in certain tables, which i have created a trigger on them calling a function from a custom dynamic extension. the extension needs to rebuild (make && make install) against new PG development header files. On Sun, Jun

Re: Postgresql 12 Beta2 Crashes for any Insert/Update

2019-06-30 Thread Mohsen Bande
I've created a new database, and started to copy current data into it. it seems to work. it seems that the problem relates to upgrade process of database catalogs from Beta1 to Beta2. if the problem persists, it will investigate the stacktrace. Thanks On Thu, Jun 27, 2019 at 9:40 PM Peter Geoghega

Re: "Time of latest checkpoint" stays too old on both master and slave

2019-06-30 Thread rihad
On 06/30/2019 10:59 AM, rihad wrote: Damn. Sorry, and please disregard my post. The master server had the wrong time. Not wrong TZ, simply wrong time. $ date Sun Jun 30 08:34:52 +04 2019 while it's currently 10:58 There's a weird problem, even when the time is initially set by openntpd it k