Postgres Pro
Downloads
Home   >   mailing lists

org.postgresql.util.PSQLException: Error could not open file "base/":No such file or directory - Mailing list pgsql-general

From Raghavendra Rao J S V
Subject org.postgresql.util.PSQLException: Error could not open file "base/":No such file or directory
Date
Msg-id CAEHH7R4M1OjhG8aZNkV0JWGkTBUwaTjssN-bgkvp5iGb+sXLpg@mail.gmail.com
Whole thread Raw
Responses RE: org.postgresql.util.PSQLException: Error could not open file"base/": No such file or directory  (Alvaro Aguayo Garcia-Rada <aaguayo@opensysperu.com>)
Re: org.postgresql.util.PSQLException: Error could not open file"base/": No such file or directory  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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

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

pgsql-general by date:

Previous
From: Michael Paquier
Date:
Subject: Re: Best options for new PG instance
Next
From: Alvaro Aguayo Garcia-Rada
Date:
Subject: RE: org.postgresql.util.PSQLException: Error could not open file"base/": No such file or directory