|
I am running PostgreSQL 8.1.3/Win Earlier yesterday, it appeared that the server stopped
responding. I went through the log files and noticed the following type
of entries. 22462 is the filenode for my database. I could not
find what the other two are. 2006-05-24 12:16:35 LOG: could not fsync segment 0 of
relation 1663/22462/18193301: Permission denied 2006-05-24 12:16:35 ERROR: storage sync failed on
magnetic disk: Permission denied Today, I managed to get the server to act up in the same
manner. Using pgAdmin, I had turned on logging to isolate a problem
coming on from a query being autogenetrated by a monitoring system. When I turned off the logging, saved the file, and sent a
trigger to to reload the config it happened again. The log entries for that chain of events are as follows: 2006-05-25 12:42:53 LOG: statement: SELECT
pg_reload_conf() 2006-05-25 12:42:53 LOG: duration: 31.000 ms 2006-05-25 12:42:53 LOG: received SIGHUP, reloading
configuration files 2006-05-25 12:42:53 LOG: duration: 422.000 ms 2006-05-25 12:42:53 LOG: could not fsync segment 0 of
relation 1663/22462/18329383: Permission denied 2006-05-25 12:42:53 ERROR: storage sync failed on
magnetic disk: Permission denied 2006-05-25 12:42:54 LOG: could not fsync segment 0 of
relation 1663/22462/18329383: Permission denied Thanks in advance. Regards, Benjamin |
