PostgreSQL 7.4RC1 crashes on Panther

Поиск
Список
Период
Сортировка
От Scott Goodwin
Тема PostgreSQL 7.4RC1 crashes on Panther
Дата
Msg-id B55DEAE4-0E3B-11D8-ACE4-000A95A0910A@scottg.net
обсуждение исходный текст
Ответы Re: PostgreSQL 7.4RC1 crashes on Panther
Список pgsql-bugs
I've encountered a problem where the PostgreSQL database crashes when
attempting to load pltcl.so on Mac OS 10.3. PostgreSQL fails because
memory cannot be allocated during a shmget call. Here is the exact
error message:

FATAL:  could not create shared memory segment: Cannot allocate memory
DETAIL:  Failed system call was shmget(key=5432001, size=3809280,
03600).
HINT:  This error usually means that PostgreSQL's request for a shared
memory segment exceeded available memory or swap space. To reduce the
request size (currently 3809280 bytes), reduce PostgreSQL's
shared_buffers parameter (currently 300) and/or its max_connections
parameter (currently 50).
         The PostgreSQL documentation contains more information about
shared memory configuration.


Here's the code that triggers it:

create function pltcl_call_handler() RETURNS LANGUAGE_HANDLER
    as 'pltcl.so' language 'c';


I have 1GB of memory and very little running on the powerbook (I
rebooted just to be sure I started with a clean system).

Not sure whether this is a PostgreSQL problem or a Mac OS 10.3 problem,
but I can load plpgsql.so right before loading pltcl.so and it still
only fails on the pltcl.so load. Commenting out the plpgsql.so load and
trying again it still fails on the pltcl.so load. I'm compiling against
a locally compiled version of Tcl 8.4.4. Here are the configure
settings:

./configure \
     --prefix=$INSTALL/postgresql \
     --with-tcl \
     --with-tclconfig=$INSTALL/tcl/lib \
     --with-includes=$INSTALL/tcl/include:$INSTALL/readline/include \
     --with-libraries=$INSTALL/readline/lib \
     --without-tk \
     --without-openssl


thanks,

/s.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: ""
Дата:
Сообщение: Re: Possible bug in conversion_create.sql
Следующее
От: Tom Lane
Дата:
Сообщение: Re: PostgreSQL 7.4RC1 crashes on Panther