Re: [ADMIN] Pgsql crashes frequently

[Ganesan Kanavathy]

Title: Message

When I check the logfile it is stated there:

"pcMemoryCreate: shmget(key=5432001, size=1466368, 03600) failed: Invalid argument

This error usually means that PostgreSQL's request for a shared memory segment exceeded your kernel's SHMMAX parameter.  You can either reduce the request size or reconfigure the kernel with larger SHMMAX.

To reduce the request size (currently 1466368 bytes), reduce PostgreSQL's shared_buffers parameter (currently 64) and/or its max_connections parameter (currently 32).

If the request size is already small, it's possible that it is less than your kernel's SHMMIN parameter, in which case raising the request size or reconfiguring SHMMIN is called for.

The PostgreSQL Administrator's Guide contains more information about shared memory configuration."

I really got no idea what this means. How do I solve this?

What SHMMAX and SHMMIN and how I calculate this value? I have a 1GB of memory.

Regards,
ganesh





-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of scott.marlowe
Sent: Tuesday, October 07, 2003 10:36 PM
To: Ganesan Kanavathy
Cc: [EMAIL PROTECTED]
Subject: Re: [ADMIN] Pgsql crashes frequently


On Tue, 7 Oct 2003, Ganesan Kanavathy wrote:

> We are running Postgresql db and it crashes almost every hour Unable
> to load up pgsql after a crash.
> 
> We need to restart the server to start back pg.
> 
> What would be the cause of this problem. Please help.

Bad hardware.  Check for bad memory, CPU, or hard drive.

Or, your machine is running low on memory and the kernel is killing
processes randomly to free up memory.  That's not as likely, but it does
happen in some setups.

www.memtest86.com for a decent free memory tester for X86 architecture.


---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html