Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1YOB8e-00054o-6C for pgsql-admin@arkaria.postgresql.org; Wed, 18 Feb 2015 20:22:28 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1YOB8c-000524-FE for pgsql-admin@arkaria.postgresql.org; Wed, 18 Feb 2015 20:22:26 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256) (Exim 4.80) (envelope-from ) id 1YOB3Q-0006xv-Aw for pgsql-admin@postgresql.org; Wed, 18 Feb 2015 20:17:04 +0000 Received: from nm20-vm5.bullet.mail.ne1.yahoo.com ([98.138.91.242]) by magus.postgresql.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:256) (Exim 4.80) (envelope-from ) id 1YOB3H-0004uA-Sf for pgsql-admin@postgresql.org; Wed, 18 Feb 2015 20:16:58 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ymail.com; s=s2048; t=1424290613; bh=3uUf57YTdHsBqzP9nav4NynZTo2NsmN6J8zw9pC/Hbc=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject; b=V01Mtr7ILgZLFa4EC6NHWYXr+4dP5YDvGXak9bmcZuearUQCJWninnRElMxLVmZiHXP2o7TndTKpuSMkUrhCOH89CLathB9ogrked22lVANM8kLhQmSdOK4GpraVj1nIVYzJlHfbqcr42n4XpVigetIXEIt0gdb19j+HL94YkxLt49g72YidSca5+8i6vH3hzurF1yUPbo2lplM2OpBA9B1CpMeQHYzFnuvvMG1FS5RDyahc8qobhGxm0PbxHFpMTYirMZgiDSuD4g8EX6X1qJDUvIJ+p4olV8NZ0US9CLUqkRwqoCyExpwA34b5Q2UsRX8A477/S9cq2TQfEWD4iQ== Received: from [98.138.226.180] by nm20.bullet.mail.ne1.yahoo.com with NNFMP; 18 Feb 2015 20:16:53 -0000 Received: from [98.138.89.240] by tm15.bullet.mail.ne1.yahoo.com with NNFMP; 18 Feb 2015 20:16:53 -0000 Received: from [127.0.0.1] by omp1013.mail.ne1.yahoo.com with NNFMP; 18 Feb 2015 20:16:53 -0000 X-Yahoo-Newman-Property: ymail-3 X-Yahoo-Newman-Id: 147126.10787.bm@omp1013.mail.ne1.yahoo.com X-YMail-OSG: XxLPI70VM1kM8ET9IwdvhOXrqMFEMVLCaMfDZzRvDAAfX3IxHhzSYkT3HWv83pM Rqt5tH6j8h6VLxXAYUrPd8tl7qi1HmEj03gHFh5lGmESdsr9T1oHW4oNfGnrA.02LMv8uhlS0c1. vv662AAb86qIt8iPzfP_4B9a3z3iXURXcBAfvMQ6_QYA__zqiwNOPpivqmSvvI8l7TDnNMU.DWbf 6AGTvO_UlWXjHld_Sq6QmJ7_cu_nRyEI6DSRBfwA6n9.gDnt6lul_6N6DV_hMG4jeuvXWarpZDM3 2jms_oDaEkDJJ9_fJh1_ySZZ42Xdvsh7d8HHhfoe3tj1KFif.FJ.P16.8.vf5daxxBj1GfPumAoJ nbNYYUEKamCBDbqD4S6L8W8a4YAtHpubYMbJUo0rn7zteo7BI3Gh2NQ4tB.5cITCIZuyP2JTtihz X6HGZefwqMgDEG8ePGO00VXLvRwzHIta5q0OdBgKL_XVG8UTsEZxVklmu2fdWfUeFkxr04sX_k4J HpkiB4t0eG7ulYo92apAbMV3t0nqYFLi9j6hhcQzWA_vXlqS_JycKzi6foG1WYwJ8anBPfFhMxp6 heoNuHg0rp4_Yrwf554hbUg-- Received: by 98.138.101.170; Wed, 18 Feb 2015 20:16:52 +0000 Date: Wed, 18 Feb 2015 20:16:52 +0000 (UTC) From: Kevin Grittner Reply-To: Kevin Grittner To: girish R G peetle Cc: pgsql-admin Message-ID: <439854218.872886.1424290612172.JavaMail.yahoo@mail.yahoo.com> In-Reply-To: References: Subject: Re: PostgreSQL File System Based Backup Restartability MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Length: 436 X-Pg-Spam-Score: -2.0 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org girish R G peetle wrote: > What if a file that got partially copied disappears (say it > belonged to a table n table was dropped ) when I resume backup. > Should I mark this partially copied file invalid in backup media ? It doesn't much matter. WAL replay will delete the file if found, and must tolerate a missing file. -- Kevin Grittner EDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin