Virus software and PostgreSQL on Windows2000

From: "Colin Mangiagalli" <colin(at)camara(dot)co(dot)za>
To: <pgsql-cygwin(at)postgresql(dot)org>
Subject: Virus software and PostgreSQL on Windows2000
Date: 2003-02-10 07:34:20
Message-ID: 010d01c2d0d6$d75c62d0$7201a8c0@camara.co.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-cygwin

Hi

I am running PostgreSQL 7.2.1-2 with cygwin dll 1.3.12-2 on Windows2000
Pro, Service Pack 2

I am using McAfee's virus software and have set VShield to exclude
scanning the cygwin and pgdata folder.

I have the following problem though. Postmaster sometimes does down with
the following error (see below).

Could the virus scanning software be causing this.

Thanks


ERROR: cannot read block 0 of modem_pkey: Permission denied
NOTICE: Error occurred while executing PL/pgSQL function
modem_updatesignalstrength
NOTICE: line 7 at SQL statement
ERROR: cannot read block 0 of modem_pkey: Permission denied
NOTICE: Error occurred while executing PL/pgSQL function
modem_updatesignalstrength
NOTICE: line 7 at SQL statement
DEBUG: mdblindwrt: write() failed: Permission denied
ERROR: cannot write block 262 of 16557/16572 blind: Permission denied
NOTICE: Error occurred while executing PL/pgSQL function
modem_updatesignalstrength
NOTICE: line 7 at SQL statement
ERROR: cannot extend messages: Permission denied.
Check free disk space.
FATAL 2: write of log file 4, segment 24, offset 12312576 failed:
Permission denied
DEBUG: server process (pid 2324) exited with exit code 2
DEBUG: terminating any other active server processes
NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend
died abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am
going to terminate your database system connection and exit.
Please reconnect to the database system and repeat your query.
NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend
died abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am
going to terminate your database system connection and exit.
Please reconnect to the database system and repeat your query.
NOTICE: Message from PostgreSQL backend:
The Postmaster has informed me that some other backend
died abnormally and possibly corrupted shared memory.
I have rolled back the current transaction and am
going to terminate your database system connection and exit.
Please reconnect to the database system and repeat your query.
DEBUG: all server processes terminated; reinitializing shared memory
and semaphores
IpcMemoryCreate: shmget(key=5432001, size=2048000, 03600) failed: Not
enough core

This error usually means that PostgreSQL's request for a shared
memory segment exceeded available memory or swap space.
To reduce the request size (currently 2048000 bytes), reduce
PostgreSQL's shared_buffers parameter (currently 100) and/or
its max_connections parameter (currently 50).

The PostgreSQL Administrator's Guide contains more information about
shared memory configuration.



Browse pgsql-cygwin by date

  From Date Subject
Next Message Jason Tishler 2003-02-10 13:52:26 Re: FW: Latest cygwin always crashing with Postgres
Previous Message Seth Rubin 2003-02-10 04:47:28 Re: FW: Latest cygwin always crashing with Postgres