Thread: could not open file "pg_subtrans/0014": Invalid argument
I have gotten this error before and it was attributed to my anti virus program. I am running Postgres 8.1 on Windows XP. I am using Nod32 as my anti virus program. I have tried adjusting Nod so it does not scan Postgres and I am still getting the error. Long story short, Can someone recommend me an anti virus program for Windows that does not interfere with Postgres? 2008-09-14 12:00:11 ERROR: could not access status of transaction 1374659 2008-09-14 12:00:11 DETAIL: could not open file "pg_subtrans/0014": Invalid argument -- Thanks, Warren Bell 909-645-8864 warren@clarksnutrition.com
On Mon, Sep 15, 2008 at 5:33 PM, Warren Bell <warren@clarksnutrition.com> wrote: > I have gotten this error before and it was attributed to my anti virus > program. I am running Postgres 8.1 on Windows XP. I am using Nod32 as my > anti virus program. I have tried adjusting Nod so it does not scan Postgres > and I am still getting the error. > > Long story short, Can someone recommend me an anti virus program for Windows > that does not interfere with Postgres? Can't you tell your anti-virus software to stop looking certain directories? More importantly, at least as far as servers are concerned, why would you need anti-virus software? Shouldn't the server be isolated in such a way that only the pgslq port 5432 is accessible by anything other than an admin?
Scott Marlowe wrote: > On Mon, Sep 15, 2008 at 5:33 PM, Warren Bell <warren@clarksnutrition.com> wrote: >> I have gotten this error before and it was attributed to my anti virus >> program. I am running Postgres 8.1 on Windows XP. I am using Nod32 as my >> anti virus program. I have tried adjusting Nod so it does not scan Postgres >> and I am still getting the error. >> >> Long story short, Can someone recommend me an anti virus program for Windows >> that does not interfere with Postgres? > > Can't you tell your anti-virus software to stop looking certain directories? I believe the OP said he did that.. It is often not enough though. Check if you can disable all scanning of activity occurring from postgres.exe - that sometimes helps. > More importantly, at least as far as servers are concerned, why would > you need anti-virus software? Shouldn't the server be isolated in > such a way that only the pgslq port 5432 is accessible by anything > other than an admin? This, however, is the proper solution. //Magnus
On 16/09/2008 01:54, Scott Marlowe wrote: > On Mon, Sep 15, 2008 at 5:33 PM, Warren Bell <warren@clarksnutrition.com> wrote: >> I have gotten this error before and it was attributed to my anti virus >> program. I am running Postgres 8.1 on Windows XP. I am using Nod32 as my >> anti virus program. I have tried adjusting Nod so it does not scan Postgres >> and I am still getting the error. >> >> Long story short, Can someone recommend me an anti virus program for Windows >> that does not interfere with Postgres? > > Can't you tell your anti-virus software to stop looking certain directories? > > More importantly, at least as far as servers are concerned, why would > you need anti-virus software? Shouldn't the server be isolated in > such a way that only the pgslq port 5432 is accessible by anything > other than an admin? In fairness, if he's running XP it's unlikely to be a server - maybe a development laptop or such, at a guess. Ray. ------------------------------------------------------------------ Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland rod@iol.ie Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals ------------------------------------------------------------------