Mueretee Mueretee - 1 year ago 160
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 ?


Answer Source

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.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download