pgstat wait timeout : permission denied
От | pandorino |
---|---|
Тема | pgstat wait timeout : permission denied |
Дата | |
Msg-id | 1340092709897-5713236.post@n5.nabble.com обсуждение исходный текст |
Ответы |
Re: pgstat wait timeout : permission denied
|
Список | pgsql-general |
Hi All my configuration: (-) postgres 9.1 (-) windows 2003 (-) 4 Xeon CPUs (-) 16GB of RAM I'm getting a lot of errors in my postgres log file: ------------------------------- 2012-06-19 09:31:06 CESTLOCATION: backend_read_statsfile, .\src\backend\postmaster\pgstat.c:3807 2012-06-19 09:31:38 CESTWARNING: 01000: pgstat wait timeout 2012-06-19 09:31:38 CESTLOCATION: backend_read_statsfile, .\src\backend\postmaster\pgstat.c:3807 2012-06-19 09:31:58 CESTWARNING: 01000: pgstat wait timeout 2012-06-19 09:31:58 CESTLOCATION: backend_read_statsfile, .\src\backend\postmaster\pgstat.c:3807 2012-06-19 09:32:58 CESTWARNING: 01000: pgstat wait timeout 2012-06-19 09:32:58 CESTLOCATION: backend_read_statsfile, .\src\backend\postmaster\pgstat.c:3807 2012-06-19 09:33:38 CESTWARNING: 01000: pgstat wait timeout 2012-06-19 09:33:38 CESTLOCATION: backend_read_statsfile, .\src\backend\postmaster\pgstat.c:3807 2012-06-19 09:33:41 CESTLOG: 42501: could not rename temporary statistics file "pg_stat_tmp/pgstat.tmp" to "pg_stat_tmp/pgstat.stat": Permission denied ------------------------------- and that's really odd: I mean, when postgres starts, it creates the file pg_stat_tmp/pgstat.stat, so it means that it has all the permissions to access to that folder. But, nevertheless, after some time it shows the error above. And these are repeadtly shown in the postgres log file. Tried to change the folder/file permissions to "everyone full control", but nothing changes. Do you have some hints/idea? Thanks in advance -- View this message in context: http://postgresql.1045698.n5.nabble.com/pgstat-wait-timeout-permission-denied-tp5713236.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
В списке pgsql-general по дате отправления: