From: preeti soni <preeti_soni123@yahoo.com>
To: pgsql-admin@lists.postgresql.org
Subject: Missing files in pg_xlog, pg_subtrans and pg_clog directories during file system based backup
Date: Tue, 12 Dec 2017 06:33:32 +0000 (UTC)
Message-ID: <1327412372.3442819.1513060412183@mail.yahoo.com> (raw)
References: <1327412372.3442819.1513060412183.ref@mail.yahoo.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: preeti_soni123@yahoo.com, pgsql-admin@lists.postgresql.org
Subject: Re: Missing files in pg_xlog, pg_subtrans and pg_clog directories during file system based backup
In-Reply-To: <1327412372.3442819.1513060412183@mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox