Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eOhH3-0008Dx-4r for pgsql-admin@arkaria.postgresql.org; Tue, 12 Dec 2017 09:54:53 +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 1eOhH2-0002AK-IG for pgsql-admin@arkaria.postgresql.org; Tue, 12 Dec 2017 09:54:52 +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 1eOhH2-0002AB-6E for pgsql-admin@lists.postgresql.org; Tue, 12 Dec 2017 09:54:52 +0000 Received: from sonic305-20.consmr.mail.ne1.yahoo.com ([66.163.185.146]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eOhGz-0005XR-2G for pgsql-admin@lists.postgresql.org; Tue, 12 Dec 2017 09:54:51 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1513072485; bh=sFaLEqlSl/MknTFoWixdIxNZZDUpnstbDAr693JFEBs=; h=Date:From:To:Cc:In-Reply-To:References:Subject:From:Subject; b=EeAiLvF6aGJX7v53MXTSZGaTt4dvHDALcakCSMsLJNdb2bGK8XGgjLGP5w+GQIwu4vRbgPf1Puk2XMJT2GYE0t8FL9wCtAvEhDL4iWbDmNLIPuaH3DfjlOsLW8Ux82RpecKTquf8+fZGXki9kzqlaUK5zq9J8QiJbQdSOAJ51J799vBUFoxeZIN/b3Zz2CcjHqzx6g20bPY4bO0E7sD/cLtlCBlcOP4XBCla5h2eqdrUX80qajgCLn0t2/sscSiyRFDBmukfZkYPx1HOqpCPSTH7reqXNW9FkXQNJo9IpfgRHUdRSaCQZyqeLH5Zf0jaME4ajG7aWYR3Aq5Z7FUwiw== X-YMail-OSG: baVtKEoVM1n28.Smq_CPWnUn.EyqKPr3BsFEq6.o1K6Gv4WQnWuOmOo7p5gHBsD _C3VKj1T_fEaoqd_lF36NGrmOU_.VpeyJXUujaiOkvb6BgNY4nse9QQlq.tKPNnnOWFTqODp72G. VJQNSLYelfyrdOjIXYHTr8QggAjLQDXwM0kiW5zn1ShW0PW2f4ZjYOMTvob.ORh5FuPcp34LtXhI xrJu8rOOpEu1dnj.hFL033BPi.360gZEzG85e9IxZ4weISKDmvEmOcNS_lbUgms2K1zsYcZmXOiL JNzH_MiHG9P0QJwHXghJpAL2v62fXHBNe.soHEmA7Vm5n4jTEz5gaeXr6CJplodWnPCriaGNP8m9 7Jjb4J3XzCfjyxeuH4XI.jZO41Azb23W2Jf5bbB0ibESfVcB.inGvA2zMTUiDfofvygLZuzK3p3x DiRGOLi6JZOJ9YBrXEuhRlMAOaGrOH1dh3t5uaPjpvnMoB.LnrWYngDbCHW1iKMIODMof3jFLF_G kbze.1vIN_RI- Received: from sonic.gate.mail.ne1.yahoo.com by sonic305.consmr.mail.ne1.yahoo.com with HTTP; Tue, 12 Dec 2017 09:54:45 +0000 Date: Tue, 12 Dec 2017 09:54:40 +0000 (UTC) From: preeti soni To: Shreeyansh Dba Cc: pgsql-admin@lists.postgresql.org Message-ID: <117040065.3494444.1513072480987@mail.yahoo.com> In-Reply-To: References: <1327412372.3442819.1513060412183.ref@mail.yahoo.com> <1327412372.3442819.1513060412183@mail.yahoo.com> Subject: Re: 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_3494443_1305048030.1513072480983" 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: 8301 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk ------=_Part_3494443_1305048030.1513072480983 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Thanks Shreeyansh for prompt response!! I am checking server logs. Will update the thread with findings. Thanks,Preeti On Tuesday, December 12, 2017, 12:50:56 PM GMT+5:30, Shreeyansh Dba wrote: =20 =20 =20 On Tue, Dec 12, 2017 at 12:03 PM, preeti soni wr= ote: Hi, While performing file system based backup, after running pg_start_backup, w= e 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 =E2=80=8B=E2=80=8Bpg_xlog, pg_subtrans and pg_clog dire= ctory. It means, the files were present when list of files is created (Coll= ect file). However, it is not there while backing up. Is the backup valid with these failed files. Any suggestion would help us. =E2=80=8BNo, the backup with missing files in=C2=A0=E2=80=8Bpg_xlog, pg_sub= trans and pg_clog directory Please do check your server logs for more details where the error is occurr= ing actually Thanks in advance!! Regards,Preeti --=20 =20 ------=_Part_3494443_1305048030.1513072480983 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Thanks Shreeyansh for prompt response!!

I am checking server logs. Will update the thread with findings.


Thanks,
Preeti
=20
=20
On Tuesday, December 12, 2017, 12:50:56 PM GMT+5:30= , Shreeyansh Dba <shreeyansh2014@gmail.com> wrote:




On Tue, Dec 12, 2017 at 12:03 PM, = preeti soni <preeti_soni123@yahoo.com> wrote:
=
Hi,

While performing file syst= em based backup, after running pg_start_backup, we create a list of files i= n data directory called collect file.
Then backup the files liste= d in collect file.

This is approxim= ately 35TB database. Very frequently we are noticing there are failed files= in
=E2=80=8B=E2=80=8B
pg_xlog, pg_subtrans and pg_clog direc= tory. It means, the files were present when list of files is created (Colle= ct file). However, it is not there while backing up.

Is the backup valid with these failed files. Any suggesti= on would help us.

=E2=80=8BNo, the backup with missing files in 
=E2=80=8B
pg_xlog, pg_subtrans a= nd pg_clog directory
Please do check your server logs for= more details where the error is occurring actually

Thanks in advance!!

Regards,
Preeti
=




--
3D"http:/=
------=_Part_3494443_1305048030.1513072480983--