Hi,
I'm getting more and more errors in the postgres log along the lines of :
2006-06-26 14:53:40 LOG: could not fsync segment 0 of relation 1663/16672/50807554: Permission denied
2006-06-26 14:53:40 ERROR: storage sync failed on magnetic disk: Permission denied
Maybe I could understand this better if I could trace the error back to a specific table/index etc. When I get the error eg "... relation 1663/16672/50807554" I can see a file under the postgres data area whos name is the last number - but how do I trace whats in that file? Is there some way of doing this using system tables or something else? And what do the first two numbers in the error represent?
Many thanks for any light anyone can shed on this.
- Barry