Re: pgbasebackup is failing after truncate

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
thatdirectory.
 

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@gmail.com] 
Sent: Tuesday, August 16, 2016 5:51 AM
To: Jeff Janes
Cc: Yelai, Ramkumar (CT DD DS AA DF-PD FH ES); pgsql-general@postgresql.org
Subject: Re: [GENERAL] pgbasebackup is failing after truncate

On Sat, Aug 13, 2016 at 12:41 AM, Jeff Janes <jeff.janes@gmail.com> wrote:
> On Wed, Aug 10, 2016 at 11:06 PM, Yelai, Ramkumar 
> <ramkumar.yelai@siemens.com> 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@wrigleys.postgresql.org
If you have ideas about making a difference between a real permission error and STATUS_PENDING_DELETE, that would be
great.
--
Michael