Missing files in pg_xlog, pg_subtrans and pg_clog directories during file system based backup

From: preeti soni <preeti_soni123(at)yahoo(dot)com>
To: <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Missing files in pg_xlog, pg_subtrans and pg_clog directories during file system based backup
Date: 2017-12-12 06:33:32
Message-ID: 1327412372.3442819.1513060412183@mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Shreeyansh Dba 2017-12-12 07:20:24 Re: Missing files in pg_xlog, pg_subtrans and pg_clog directories during file system based backup
Previous Message Marcelo Kruger 2017-12-10 21:59:36 Re: [ADMIN] High replication lag - Stream Replication