1. Postgres 9.1 environment
2. Database reported missing before the chunk number x for a bigger value x in pg_toast_x, then the query is pg_statistics,
3. When reindex table pg_statistic, tip could not access the status of the transaction XXX, could not open the file "pg_subtrans/001 c," no to fle or directory.
There is no this file under the directory,
Could you tell me how to solve this, thank you!

CodePudding user response:

Check the file and directory permissions distribution is correct

CodePudding user response:

reference 1st floor ZJCXC response:

check file and directory permissions distribution is properly

reference 1st floor ZJCXC response:

check file and directory permissions distribution is properly

Thank you very much, the problem has been resolved, it should be the current log is lost, the database of the transactionID after reset, ok,