From: | pandorino <pandorino(dot)mdg(at)tiscalinet(dot)it> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | pgstat wait timeout : permission denied |
Date: | 2012-06-19 07:58:29 |
Message-ID: | 1340092709897-5713236.post@n5.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Stefan Schwarzer | 2012-06-19 08:32:57 | Re: Error message "psql: could not connect to server: No such file or directory" |
Previous Message | Hitoshi Harada | 2012-06-19 07:32:59 | Re: How to include Tablefunc as an extension |