Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ecZSL-0005Pg-Tn for pgsql-admin@arkaria.postgresql.org; Fri, 19 Jan 2018 16:23:54 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ecZSK-0002Y0-Ot for pgsql-admin@arkaria.postgresql.org; Fri, 19 Jan 2018 16:23:52 +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.84_2) (envelope-from ) id 1ecZSK-0002Xr-Ej for pgsql-admin@lists.postgresql.org; Fri, 19 Jan 2018 16:23:52 +0000 Received: from host3.dynacom.ondsl.gr ([62.103.35.211] helo=smadev.internal.net) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1ecZSG-0004sn-Gq for pgsql-admin@lists.postgresql.org; Fri, 19 Jan 2018 16:23:51 +0000 Received: from smadev.internal.net (smadev [10.9.200.131]) by smadev.internal.net (8.15.2/8.15.2) with ESMTP id w0JGNf5k041744 for ; Fri, 19 Jan 2018 18:23:42 +0200 (EET) (envelope-from achill@matrix.gatewaynet.com) Subject: Re: backup postgresql with snapshot AWS To: pgsql-admin@lists.postgresql.org References: <166191299.1443519.1516368751643@mail.virgilio.it> <58e57feb-1a0a-bb44-55a6-5c94d294de9e@pgmasters.net> <2ce36d42-c90a-ed10-173d-7b8445c1cec9@denninger.net> From: Achilleas Mantzios Message-ID: Date: Fri, 19 Jan 2018 18:23:41 +0200 User-Agent: Mozilla/5.0 (X11; FreeBSD amd64; rv:52.0) Gecko/20100101 Thunderbird/52.5.2 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 19/01/2018 17:40, Rui DeSousa wrote: > If the snapshot is not atomic and/or using multiple filesystems; that is fine as long as it’s issued and completed within the pg_start_backup() and pg_stop_backup() calls. And as long as the needed wals belonging to that interval between start and stop are to be found in the archive when the problem arises. So the whole system must be well documented and periodically tested. > -- Achilleas Mantzios IT DEV Lead IT DEPT Dynacom Tankers Mgmt