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

From: Raghavendra Rao J S V <raghavendrajsv(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: org.postgresql.util.PSQLException: Error could not open file "base/": No such file or directory
Date: 2018-03-06 01:54:03
Message-ID: CAEHH7R4M1OjhG8aZNkV0JWGkTBUwaTjssN-bgkvp5iGb+sXLpg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Aguayo Garcia-Rada 2018-03-06 02:05:24 RE: org.postgresql.util.PSQLException: Error could not open file "base/": No such file or directory
Previous Message Michael Paquier 2018-03-06 01:11:32 Re: Best options for new PG instance