Re: Missing files in pg_xlog, pg_subtrans and pg_clog directoriesduring file system based backup
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 <shreeyansh2014@gmail.com> wrote:
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 inpg_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
Please do check your server logs for more details where the error is occurring actually
pg_xlog, pg_subtrans and pg_clog directoryPlease do check your server logs for more details where the error is occurring actually
Thanks in advance!!Regards,Preeti
В списке pgsql-admin по дате отправления:
Предыдущее
От: Shreeyansh DbaДата:
Сообщение: Re: Missing files in pg_xlog, pg_subtrans and pg_clog directoriesduring file system based backup