Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 2 replies
  • Subscribers 3 subscribers
  • Views 11994 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

PostgreSQL PG_VERSION is missing error

AndrewGunnesch

My UTM9 is constantly generating these errors in logs:

 

2017:05:17-08:31:39 portal postgres[28059]: [3-1] FATAL:  "pg_tblspc/16774/PG_9.2_201204301/16775" is not a valid data directory<131>May 17 08:31:39 postgres[28059]: [3-2] DETAIL:  File "pg_tblspc/16774/PG_9.2_201204301/16775/PG_VERSION" is missing.

 

 

How can I repair this issue?

 

I saw suggestions to do this:

portal:/etc/init.d # ./postgresql92 rebuild
Rebuilding PostgreSQL database, all reporting data will be lost!

Will this remove logiles?  What exactly will be lost?

 

Thanks!



This thread was automatically locked due to age.
Unfiltered HTML