Re: [GENERAL] pgstat wait timeout : permission denied

2012-06-25 Thread Craig Ringer
On 06/26/2012 12:27 AM, pandorino wrote: Hi Craig yes, that's exactly what I did. I have the datadir in a different folder than the executable (because I created a pseudo-portable "database"). I have not set any special exception for the executables, apparently my installation does not need thi

Re: [GENERAL] pgstat wait timeout : permission denied

2012-06-25 Thread pandorino
Hi Craig yes, that's exactly what I did. I have the datadir in a different folder than the executable (because I created a pseudo-portable "database"). I have not set any special exception for the executables, apparently my installation does not need this. Everything is working fine now, however,

Re: [GENERAL] pgstat wait timeout : permission denied

2012-06-20 Thread Craig Ringer
On 06/20/2012 08:31 PM, pandorino wrote: Hi all just to close the post and let you know: it was the antivirus (McAfee). Now I have to see how to create an exception on this folder, because of course I would keep the antivirus running. You'll probably also want to set an exception on the folder

Re: [GENERAL] pgstat wait timeout : permission denied

2012-06-20 Thread pandorino
Hi all just to close the post and let you know: it was the antivirus (McAfee). Now I have to see how to create an exception on this folder, because of course I would keep the antivirus running. Thanks Alban for the hint. Regards -- View this message in context: http://postgresql.1045698.n5.nab

Re: [GENERAL] pgstat wait timeout : permission denied

2012-06-19 Thread Dickson S. Guedes
2012/6/19 Alban Hertroys : >> 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/pgsta

Re: [GENERAL] pgstat wait timeout : permission denied

2012-06-19 Thread pandorino
hmm, interesting idea. I'll check, it will be a bit difficult because it is centrally managed by administrators, but I will see how to temporary disable it. Thanks -- View this message in context: http://postgresql.1045698.n5.nabble.com/pgstat-wait-timeout-permission-denied-tp5713236p5713255.htm

Re: [GENERAL] pgstat wait timeout : permission denied

2012-06-19 Thread Alban Hertroys
> 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.st

[GENERAL] pgstat wait timeout : permission denied

2012-06-19 Thread pandorino
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 CES

Re: [GENERAL] pgstat wait timeout

2012-04-20 Thread Fujii Masao
On Thu, Apr 19, 2012 at 3:32 AM, Efraín Déctor wrote: > Hello list: > > Today I started to see this messages on the PostgreSQL log: > > 2012-04-18 00:01:05 UTC : @  :WARNING:  01000: pgstat wait timeout > 2012-04-18 00:01:05 UTC : @  :LOCATION:  backend_read_statsfile, > pgstat.c:3807 > > I search

Re: [GENERAL] pgstat wait timeout

2012-04-19 Thread tuanhoanganh
I have same problem too. Tuan Hoang Anh On Thu, Apr 19, 2012 at 10:43 PM, Efraín Déctor wrote: > Any help will be appreciated. > > Thanks. > > *From:* Efraín Déctor > *Sent:* Wednesday, April 18, 2012 1:32 PM > *To:* pgsql-general@postgresql.org > *Subject:* pgstat wait timeout > > Hello l

Re: [GENERAL] pgstat wait timeout

2012-04-19 Thread Efraín Déctor
Any help will be appreciated. Thanks. From: Efraín Déctor Sent: Wednesday, April 18, 2012 1:32 PM To: pgsql-general@postgresql.org Subject: pgstat wait timeout Hello list: Today I started to see this messages on the PostgreSQL log: 2012-04-18 00:01:05 UTC : @ :WARNING: 01000: pgstat wait t

[GENERAL] pgstat wait timeout

2012-04-18 Thread Efraín Déctor
Hello list: Today I started to see this messages on the PostgreSQL log: 2012-04-18 00:01:05 UTC : @ :WARNING: 01000: pgstat wait timeout 2012-04-18 00:01:05 UTC : @ :LOCATION: backend_read_statsfile, pgstat.c:3807 I searched and to fix it it was recommended to disable autovacuum, I did it an

[GENERAL] pgstat wait timeout

2012-03-26 Thread Norberto Dellê
Hello One of our production servers log files is being flooded with the message: 2012-03-26 00:00:11 BRT AVISO: pgstat wait timeout 2012-03-26 00:00:19 BRT AVISO: pgstat wait timeout 2012-03-26 00:00:31 BRT AVISO: pgstat wait timeout 2012-03-26 00:00:39 BRT AVISO: pgstat wait timeout 2012-03-

[GENERAL] pgstat wait timeout

2011-03-15 Thread Norberto Delle
Hello everyone Our system: Windows Server 2008 R2 Foundation PostgreSQL 9.0.1 64 bits Days ago, the following message began to appear in the logs every 50 seconds: 2011-03-15 00:07:06 BRT AVISO: pgstat wait timeout I searched the mailing lists. but couldn't find any useful information. Som

[GENERAL] pgstat wait timeout

2011-03-14 Thread Tory M Blue
I know you can't do much with this information, but maybe you can help me acquire the information that is needed. This started in 8.4 and trying to figure it out Fedora 12, Postgres 8.4.4 with slony. Although I don't see any panics or errors other then these Warnings, but I did see a dead lock t