BUG #3318: PostgreSQL : server process (PID 3480) was terminated by signal 5

What is signal 5 in XP? I looked in the MinGW source used to build
PostgreSQL 8.1.4 and there is no mention of a signal 5 there. I see
signal 5 mentioned here:

http://archives.postgresql.org/pgsql-bugs/2004-11/msg00175.php

and it was diagnosed as an invalid memory access.

I suggest you upgrade to the newest release of 8.1.X, 8.1.9. It does
not require you to dump your database. This might fix it:

ftp://ftp5.ca.postgresql.org/mirrors/postgresql/binary/v8.1.9/win32

---------------------------------------------------------------------------

chee leong wrote:

The following bug has been logged online:

Bug reference: 3318
Logged by: chee leong
Email address: cheeleong.chong@incenplus.com.my
PostgreSQL version: 8.1.4
Operating system: Windows XP
Description: PostgreSQL : server process (PID 3480) was terminated by
signal 5
Details:

Dear Sir/Madam,

We have 2 pc, both also install postgreSQL, but one of the pc
having problem in the middle of running program call to postgreSQL, but
another one no problem at all.

the problem as follow :

2007-05-14 09:55:36 LOG: server process (PID 3480) was terminated
by signal 5
2007-05-14 09:55:36 LOG: terminating any other active server
processes
2007-05-14 09:55:36 LOG: all server processes terminated;
reinitializing
2007-05-14 09:55:36 LOG: database system was interrupted at
2007-05-14 09:53:42 Malay Peninsula Standard Time
2007-05-14 09:55:36 LOG: checkpoint record is at 1/D50D3610

Many thanks and hope you can give some info/suggestion for solving
this problem.

Thanks and regards,
Chee Leong

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

+ If your life is a hard drive, Christ can be your backup. +

Bruce Momjian wrote:

What is signal 5 in XP? I looked in the MinGW source used to build
PostgreSQL 8.1.4 and there is no mention of a signal 5 there. I see
signal 5 mentioned here:

Access denied. Most often showed for accessing memory outside the mapped
space, so this similar to SIGSEGV.

//Magnus