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