From: | "Ian Harding" <ianh(at)tpchd(dot)org> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | tsearch trouble REPOST |
Date: | 2003-03-03 14:58:15 |
Message-ID: | se62fd24.095@mail.tpchd.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I waited 4 days and didn't see this message hit the list. Apologies if it did and I just can't find it...
I made, installed and tried to use tsearch with no problems up to the point of trying to populate an index. It consistently crashes like this...
LOG: server process (pid 27797) was terminated by signal 11
LOG: terminating any other active server processes
LOG: all server processes terminated; reinitializing shared memory and semaphores
IpcMemoryCreate: shmget(key=5432001, size=29769728, 03600) failed: Cannot allocate memory
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 29769728 bytes), reduce
PostgreSQL's shared_buffers parameter (currently 3500) and/or
its max_connections parameter (currently 21).
The PostgreSQL Administrator's Guide contains more information about
shared memory configuration.
LOG: database system was interrupted at 2003-02-28 11:18:08 PST
LOG: checkpoint record is at 2/217EBADC
I have no doubt that I have done something stupid, but where should I start looking? I used the source included in the 7.3.1 tarball, and followed the instructions...
Thanks!
Ian
From | Date | Subject | |
---|---|---|---|
Next Message | Len Morgan | 2003-03-03 15:03:05 | List Problems |
Previous Message | Tom Lane | 2003-03-03 14:52:27 | Re: plpgsql mixing variable in SELECT INTO ? |