could not open file "pg_subtrans/0014": Invalid argument

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
------------------------------------------------------------------