HI, Thanks for helpful information. Even if there is no way to fix then please let me know how long that file ( pending for deletion ) will be present in that directory. I observe like 1 or 2 hr after it will be deleted. But I am wondering, who is deleting that file. Regards, Ramkumar -----Original Message----- From: Michael Paquier [mailto:michael.paquier@xxxxxxxxx] Sent: Tuesday, August 16, 2016 5:51 AM To: Jeff Janes Cc: Yelai, Ramkumar (CT DD DS AA DF-PD FH ES); pgsql-general@xxxxxxxxxxxxxx Subject: Re: pgbasebackup is failing after truncate On Sat, Aug 13, 2016 at 12:41 AM, Jeff Janes <jeff.janes@xxxxxxxxx> wrote: > On Wed, Aug 10, 2016 at 11:06 PM, Yelai, Ramkumar > <ramkumar.yelai@xxxxxxxxxxx> wrote: >> At present, I have some requirement to truncate the data base to >> reclaim disk space and at the same time I need to take basebackup. >> >> Seems, truncate is successfully reclaimed the space but pgbasebackup >> failed and reported the below error. >> >> “could not stat file or directory ./base/16384/25600: Permission denied. > > Are you on MS Windows? If so, sounds like a possible variant of BUG > #14243 That's really the same issue... See here for more details: https://www.postgresql.org/message-id/20160712083220.1426.58667@xxxxxxxxxxxxxxxxxxxxxxx If you have ideas about making a difference between a real permission error and STATUS_PENDING_DELETE, that would be great. -- Michael -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
