Mueretee Mueretee - 4 months ago 8
SQL Question

(PostgreSQL) ERROR: could not open relation

I get this strange error

Caused by: org.postgresql.util.PSQLException: ERROR: could not open
relation base/17369/1684: No such file or directory


How do I recover from it ?
Any ideas ?

Thanks

Answer

You lost file related to table 1684 and database 17369. Check presence file with name 1684 in directory base/17369.

You can determine which table it is:

1) get database name: select * from pg_database where oid=17369

2) get table name (connect to affected database): select * from pg_class where oid=1684

Probably there is not much more you can do. Only restore from backup.