Re: 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(dot)chong(at)incenplus(dot)com(dot)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(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://www.enterprisedb.com

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