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