On Tue, 2021-12-14 at 22:26 +0530, Daulat wrote: > I am getting the below error while opening some tab/menus options in the application for a specific database. > > Caused by: org.postgresql.util.PSQLException: ERROR: could not open file "pg_tblspc/859888/PG_10_201707211/859890/876783": No such file or directory > > I see, this directory exists till pg_tblspc/859888/PG_10_201707211/859890/ > Also I am able to select/create/drop the table on that database from psql. > > Any suggestions? Is that database corrupt? > Postgres version is 10. Yes, your database is corrupt. What do you get if you connect to that database and run SELECT oid::regclass, relkind FROM pg_class WHERE relfilenode = 876783; If you can, run a pg_dump of that database *now*. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com
