| Lists: | pgsql-general |
|---|
| From: | Warren Bell <warren(at)clarksnutrition(dot)com> |
|---|---|
| To: | "'Postgres General List'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | could not open file "pg_subtrans/0014": Invalid argument |
| Date: | 2008-09-15 23:33:27 |
| Message-ID: | 48CEF0C7.609@clarksnutrition.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
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(at)clarksnutrition(dot)com
| From: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | "Warren Bell" <warren(at)clarksnutrition(dot)com> |
| Cc: | "Postgres General List" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: could not open file "pg_subtrans/0014": Invalid argument |
| Date: | 2008-09-16 00:54:21 |
| Message-ID: | dcc563d10809151754h308c53bey6619cde8b4b403aa@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
On Mon, Sep 15, 2008 at 5:33 PM, Warren Bell <warren(at)clarksnutrition(dot)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?
| From: | Magnus Hagander <magnus(at)hagander(dot)net> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | Warren Bell <warren(at)clarksnutrition(dot)com>, Postgres General List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: could not open file "pg_subtrans/0014": Invalid argument |
| Date: | 2008-09-16 08:29:43 |
| Message-ID: | 48CF6E77.6080902@hagander.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Scott Marlowe wrote:
> On Mon, Sep 15, 2008 at 5:33 PM, Warren Bell <warren(at)clarksnutrition(dot)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
| From: | Raymond O'Donnell <rod(at)iol(dot)ie> |
|---|---|
| To: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | Warren Bell <warren(at)clarksnutrition(dot)com>, Postgres General List <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: could not open file "pg_subtrans/0014": Invalid argument |
| Date: | 2008-09-16 16:45:20 |
| Message-ID: | 48CFE2A0.2090506@iol.ie |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
On 16/09/2008 01:54, Scott Marlowe wrote:
> On Mon, Sep 15, 2008 at 5:33 PM, Warren Bell <warren(at)clarksnutrition(dot)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(at)iol(dot)ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------