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

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