Hi, I have only one database and I ran query with superuser privilege. Seems this issue is related to BUG 14243. Regards, Ramkumar. -----Original Message----- From: Adrian Klaver [mailto:adrian.klaver@xxxxxxxxxxx] Sent: Friday, August 12, 2016 7:37 PM To: Yelai, Ramkumar (CT DD DS AA DF-PD FH ES); pgsql-general@xxxxxxxxxxxxxx Subject: Re: pgbasebackup is failing after truncate On 08/10/2016 11:06 PM, Yelai, Ramkumar 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. To be clear you ran TRUNCATE on tables within the database, correct? If not what was the actual command you used? > > 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. So what user did you run pg_basebackup as and does that user have rights on that file/directory? > > Further observation shows that truncate command reclaiming the space > by making empty (not deleted) these files in ./base/16384 folders. > > Seems these filename are relfilenode in pg_class table to map filename > to table name. Since truncate making empty these files and create new > files to map the old table name, pgbasebackup is unable to synch with > truncate and pointing to old files. > > Also, the old files are not deleted from "base" folder. > > Please let me know how to resolve this issue > > With best regards, > Ramkumar Yelai > > _mailto:ramkumar.yelai@siemens.com_ > _http://www.siemens.co.in/STS_ > > Registered Office: 130, Pandurang Budhkar Marg, Worli, Mumbai 400 018. > Telephone +91 22 39677000. Fax +91 22 39677075. Other Offices: > Bangalore, Chennai, Gurgaon, Noida, Kolkata, Pune. Corporate Identity > number:U99999MH1986PLC093854 > > -- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
