Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eOe8P-0005A8-GF for pgsql-admin@arkaria.postgresql.org; Tue, 12 Dec 2017 06:33:45 +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 1eOe8O-0000KN-Kg for pgsql-admin@arkaria.postgresql.org; Tue, 12 Dec 2017 06:33:44 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1eOe8O-0000KE-Bz for pgsql-admin@lists.postgresql.org; Tue, 12 Dec 2017 06:33:44 +0000 Received: from sonic302-20.consmr.mail.ne1.yahoo.com ([66.163.186.146]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eOe8H-0001Ey-26 for pgsql-admin@lists.postgresql.org; Tue, 12 Dec 2017 06:33:43 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1513060413; bh=VxuaAnUp/W01n2w+riImc93lQ5Cwwcli0aQ91IlD7Jc=; h=Date:From:To:Subject:References:From:Subject; b=FdYSnlX22/WmQmyG40MnTItzywi02IuqmQbMfzg4O2paA6y2hPMnELRVTQthehFaIhLbpH0W7eVwbrICINfqAssnH45CaY+JQCY/WpNO4+AyEXx+gV4Of0S16H5HXekVmPQPeVZJnWI4gulRZ6oquzhyAG0388Mc4QI/aWu1YpgNEzeHVDiPyGT9CPYbO4385GvVu9RakTg6I4ykvbjv8rKgEq48m2f+ACUsHacFnuelQBQky9fLNReuu5kqQpa4uNgjz3cRUMwcwHIv2OA33hluJEUwM8cg6ycH8U8OSAwlE2IifeUyLMHds9cl4z4GjxgBklQnrRJhd31XgzjFhg== X-YMail-OSG: pNHKxikVM1mAUjQ7hT3svgnr6EjF_dFF2bNiFoZfwjeCTlcXnkkRqIPzhmDBDRC o_leK4Xqp5RMhC39HV.Cxr5Khf96B_9O0dDLQEDJTW8jUQHcGYMHzqjvLzk9ULUWYBlZQ22wNCvF Y0fMEqSdUU3BFsJcZh2CjL1OZ.Tlysi2VEPnfBC_dQkzMYA2JmEYCZqXRf2cXdEcaSonfPpVYj4Z tGgkDWZ1VyQFEdKd7Q.VnbFmE1ZIJ1IKyagBywCyqcR3KRJehYmTHXGtShSOVEl0RA3DKZkYxFMz oXhQNcnoSohfMY.SjZDPyKaJV3SzbiD3iZt6msqOjPy5kKhlT4rTa4QDzuCo2_wkxHaJj8wEziYD e5vmlDU5LtNveSUn1xgjwqFJS2.9TVkuLZIKmWnVj1AogXySAl1ZzMLRxe0TOb7Te1wsrN4Ak9_c wbGkPULSqiWC83KhyGFE3Qh2tohcF1X0cad2AhgPnl9iuuuM6Uos43XKO_oGBWkzrgiY5tyFm9IV YOhY2sBY5p7rK Received: from sonic.gate.mail.ne1.yahoo.com by sonic302.consmr.mail.ne1.yahoo.com with HTTP; Tue, 12 Dec 2017 06:33:33 +0000 Date: Tue, 12 Dec 2017 06:33:32 +0000 (UTC) From: preeti soni To: Message-ID: <1327412372.3442819.1513060412183@mail.yahoo.com> Subject: Missing files in pg_xlog, pg_subtrans and pg_clog directories during file system based backup MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_3442818_1805341108.1513060412182" References: <1327412372.3442819.1513060412183.ref@mail.yahoo.com> X-Mailer: WebService/1.1.11051 YMailNorrin Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36 Content-Length: 2703 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_3442818_1805341108.1513060412182 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit Hi, While performing file system based backup, after running pg_start_backup, we create a list of files in data directory called collect file.Then backup the files listed in collect file. This is approximately 35TB database. Very frequently we are noticing there are failed files in pg_xlog, pg_subtrans and pg_clog directory. It means, the files were present when list of files is created (Collect file). However, it is not there while backing up. Is the backup valid with these failed files. Any suggestion would help us. Thanks in advance!! Regards,Preeti ------=_Part_3442818_1805341108.1513060412182 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,

<= div>While performing file system based backup, after running pg_start_backu= p, we create a list of files in data directory called collect file.
Then backup the files listed in collect file.

T= his is approximately 35TB database. Very frequently we are noticing there a= re failed files in pg_xlog, pg_subtrans and pg_clog directory. It means, th= e files were present when list of files is created (Collect file). However,= it is not there while backing up.

Is the backup v= alid with these failed files. Any suggestion would help us.
<= br>
Thanks in advance!!

Regards,
Preeti

------=_Part_3442818_1805341108.1513060412182--