Re: org.postgresql.util.PSQLException: Error could not open file"base/": No such file or directory

On 03/05/2018 05:54 PM, Raghavendra Rao J S V wrote:
> Hi,
> 
> Few of the tables and indexes are bloated though auto vacuum has enables.
> 
> Two reclaim the space vacuum, I have ran vacuum full on the larger 
> tables and also performed reindex on the indexes which are in larger 
> size. Now the size of the database is in control.
> 
> After perfoming the vacuum full and reindexing on larger tables, I am 
> facing below error.
> 
> *org.postgresql.util.PSQLException: Error could not open file "base/": 
> No such file or directory*

Assuming the database is up and running then base/ is actually there:

https://www.postgresql.org/docs/10/static/storage-file-layout.html


When I know a file or directory exists and I see an error like:

'Error could not open file "base/": No such file or directory '

then I generally check permissions on said file/directory. In particular 
does the app throwing the error having the permissions to 'see' the 
file/directory?

> 
> Please guide me how to resolve the above error and let me know does this 
> has any relation with vacumm full or reindexing operation which are 
> performed by me.
> 
> -- 
> Regards,
> Raghavendra Rao J S V
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com