Re: pgbasebackup is failing after truncate

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: "Yelai, Ramkumar" <ramkumar(dot)yelai(at)siemens(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: pgbasebackup is failing after truncate
Date: 2016-08-12 15:41:57
Message-ID: CAMkU=1xsi9i98av0TZ5YzWsyd=b=0+ie0-fh75vOnRqBemHTHA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Aug 10, 2016 at 11:06 PM, Yelai, Ramkumar
<ramkumar(dot)yelai(at)siemens(dot)com> wrote:
> HI
>
> 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

Cheers,

Jeff

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ioana Danes 2016-08-12 15:44:19 Re: Corrupted Data ?
Previous Message Adrian Klaver 2016-08-12 15:34:01 Re: Corrupted Data ?