Postgres Pro
Downloads
Home   >   mailing lists

Re: Missing files in pg_xlog, pg_subtrans and pg_clog directoriesduring file system based backup - Mailing list pgsql-admin

From Shreeyansh Dba
Subject Re: Missing files in pg_xlog, pg_subtrans and pg_clog directoriesduring file system based backup
Date
Msg-id CAGDYbUMdwVAXKqYkOLJeVZCeVFVwixxbtrWwc3wcJBsx_eCe-A@mail.gmail.com
Whole thread Raw
In response to Missing files in pg_xlog, pg_subtrans and pg_clog directoriesduring file system based backup  (preeti soni <preeti_soni123@yahoo.com>)
Responses Re: Missing files in pg_xlog, pg_subtrans and pg_clog directoriesduring file system based backup  (preeti soni <preeti_soni123@yahoo.com>)
List pgsql-admin
Tree view


On Tue, Dec 12, 2017 at 12:03 PM, preeti soni <preeti_soni123@yahoo.com> wrote:
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.

​No, the backup with missing files in 
​
pg_xlog, pg_subtrans and pg_clog directory
Please do check your server logs for more details where the error is occurring actually

Thanks in advance!!

Regards,
Preeti




--
http://www.shreeyansh.com

pgsql-admin by date:

Previous
From: preeti soni
Date:
Subject: Missing files in pg_xlog, pg_subtrans and pg_clog directoriesduring file system based backup
Next
From: preeti soni
Date:
Subject: Re: Missing files in pg_xlog, pg_subtrans and pg_clog directoriesduring file system based backup