Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1erGbZ-0001YZ-G3 for pgsql-admin@arkaria.postgresql.org; Thu, 01 Mar 2018 05:18:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1erGbY-0002mW-Jn for pgsql-admin@arkaria.postgresql.org; Thu, 01 Mar 2018 05:18:08 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1erGbY-0002fi-8U for pgsql-admin@lists.postgresql.org; Thu, 01 Mar 2018 05:18:08 +0000 Received: from mr28p48im-tydg10101201.me.com ([17.110.88.44]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1erGbU-0005eY-RT for pgsql-admin@lists.postgresql.org; Thu, 01 Mar 2018 05:18:07 +0000 Received: from process-dkim-sign-daemon.mr28p48im-tydg10101201.me.com by mr28p48im-tydg10101201.me.com (Oracle Communications Messaging Server 8.0.1.2.20170607 64bit (built Jun 7 2017)) id <0P4W00300BTFDK00@mr28p48im-tydg10101201.me.com> for pgsql-admin@lists.postgresql.org; Thu, 01 Mar 2018 05:18:03 +0000 (GMT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=icloud.com; s=04042017; t=1519881483; bh=JyssyhawH6dsUr/qk5LBpypkcrv8MTeGC8Kt5hECJk4=; h=Content-type:MIME-version:Subject:From:Date:Message-id:To; b=RlN5rmxm6xooR7EHUDtWEMqckHn4wzhtlFD8YwgZ0qPDVKyp1YisoIT9cqIXPeKHQ TAXSc/EwTnhMGKRgLh/2DCAiKvKlvQXB0dYXM0qQKNRkXnvc7Z64xqhV7fLZP57ZI7 Ehlb9b1yiaY+E7I6esoBDTk6ApsmnsZJBQ7dUD/4gDXKJpRcR2mtCnxngcZkxb8t+F 9PyGpAfWU5xj3WpmyOt7S7PwJrqQ+U1q+5GLOh2iOM095AvwCqwpwzgh1kBTkKWhZD 3rNBktjx0pNq22soMa/hyZLTM1w1Momb2yZGqCBur6bQRzNeEyA25PX0T6pIbJROdB bh43Dgy95SAPg== Received: from icloud.com ([127.0.0.1]) by mr28p48im-tydg10101201.me.com (Oracle Communications Messaging Server 8.0.1.2.20170607 64bit (built Jun 7 2017)) with ESMTPSA id <0P4W007N2C21M020@mr28p48im-tydg10101201.me.com>; Thu, 01 Mar 2018 05:18:03 +0000 (GMT) X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10432:,, definitions=2018-03-01_03:,, signatures=0 X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 spamscore=0 clxscore=1015 suspectscore=0 malwarescore=0 phishscore=0 adultscore=0 bulkscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.0.1-1707230000 definitions=main-1803010067 Content-type: text/plain; charset=utf-8 MIME-version: 1.0 (Mac OS X Mail 11.2 \(3445.5.20\)) Subject: Re: Reliable WAL file shipping over unreliable network From: Rui DeSousa In-reply-to: Date: Thu, 01 Mar 2018 00:18:01 -0500 Cc: Dianne Skoll , pgsql-admin@lists.postgresql.org Content-transfer-encoding: quoted-printable Message-id: <69359134-CEAE-421B-96D7-0E70C0535C17@icloud.com> References: <400AC9CD-1E43-422C-A689-70BDBAFF231E@elevated-dev.com> <37C5A42B-4CDD-4F01-8F1E-1B185C1819B9@icloud.com> <20180228132620.2c882f84@hydrogen.roaringpenguin.com> <33220469-5BB2-4A40-8F56-8F4F392C95B3@icloud.com> <21AF0CB4-0873-4960-BA14-E72FA08B352E@icloud.com> <5a49c387-e4f4-f70c-537c-9c338c80b687@catalyst.net.nz> <9DDA6F85-077E-4F8D-8708-632CC2907D3C@icloud.com> <06dd8b81-8b1a-ae5c-8ddd-1556b5946176@catalyst.net.nz> <6056907B-551F-4ED0-804B-0FCACD39EB23@icloud.com> To: Mark Kirkwood X-Mailer: Apple Mail (2.3445.5.20) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk I can tell you this; it=E2=80=99s not ZFS or it=E2=80=99s quotas. I = know that Postgres has no problems with ZFS and quotas; I have seen = Postgres development environments run out of quota space on ZFS and = Postgres never got corrupted =E2=80=94 it would just crash and end up in = a crash/restore loop. Just increase the quota and Postgres recovers = without issue exiting the crash/restore loop, cleanup the rouge space = usage, and reduce the quota back down. It makes recovering from out of = space issues very quick. =20