Re: [BUGS] My postmaster just crashed ! - Mailing list pgsql-general

From Frank D. Engel, Jr.
Subject Re: [BUGS] My postmaster just crashed !
Date
Msg-id 0A4932A7-709E-11D9-AC0F-0050E410655F@fjrhome.net
Whole thread Raw
In response to Re: [BUGS] My postmaster just crashed !  (Michael Fuhr <mike@fuhr.org>)
Responses Re: [BUGS] My postmaster just crashed !
Re: [BUGS] My postmaster just crashed !
List pgsql-general
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I think it is an internal thing with gcc that the size of a pointer and
sizeof(int) are always the same, regardless of machine word size...
with a 64-bit binary, sizeof(int) and sizeof(void *) should both be 8,
which still causes them to be equal.

On Jan 27, 2005, at 2:38 PM, Michael Fuhr wrote:

> On Thu, Jan 27, 2005 at 02:22:36PM -0500, Tom Lane wrote:
>> Michael Fuhr <mike@fuhr.org> writes:
>>> On Thu, Jan 27, 2005 at 05:26:26PM +0100, PFC wrote:
>>>> It seems that contrib/intagg crashes my server :
>>
>>> I see the same thing with PostgreSQL 8.0.0 (REL8_0_STABLE) on
>>> Solaris 9
>>> and FreeBSD 4.11.
>>
>> The intagg source code says
>>
>>     NOTE: This module requires sizeof(void *) to be the same as
>> sizeof(int)
>>
>> which in English means "this ain't gonna work on 64-bit machines".
>> I've
>> never bothered to look at it more closely than that ...
>
> Hmmm...the PostgreSQL binaries on my Solaris/sparc box are 32-bit
> and the FreeBSD box is a 32-bit i386, yet both are susceptible to
> the crash.  On both boxes, a 32-bit program shows both sizeof(void *)
> and sizeof(int) to be 4, so the problem doesn't appear to be due
> to that necessary condition not being satisfied.
>
> --
> Michael Fuhr
> http://www.fuhr.org/~mfuhr/
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings
>
>
- -----------------------------------------------------------
Frank D. Engel, Jr.  <fde101@fjrhome.net>

$ ln -s /usr/share/kjvbible /usr/manual
$ true | cat /usr/manual | grep "John 3:16"
John 3:16 For God so loved the world, that he gave his only begotten
Son, that whosoever believeth in him should not perish, but have
everlasting life.
$
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (Darwin)

iD8DBQFB+UhH7aqtWrR9cZoRAnAFAJ43uG1sfDKrorDo17SoBW1+H8k7EQCfRvfH
7yQBTSKBiqkIdQ5Oh8tL2js=
=90y9
-----END PGP SIGNATURE-----



___________________________________________________________
$0 Web Hosting with up to 120MB web space, 1000 MB Transfer
10 Personalized POP and Web E-mail Accounts, and much more.
Signup at www.doteasy.com


pgsql-general by date:

Previous
From: Stephen Frost
Date:
Subject: Re: convert mdb files to pg?
Next
From: Tom Lane
Date:
Subject: Re: [BUGS] My postmaster just crashed !