Re: Problems setting shared_buffers to large value - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Problems setting shared_buffers to large value
Date
Msg-id 407B2432.9040006@commandprompt.com
Whole thread Raw
In response to Problems setting shared_buffers to large value  ("Barry L. Geipel" <barry@GeipelNet.com>)
List pgsql-general
Hello,

What operating system?

Sincerely,

Joshua D. Drake

Barry L. Geipel wrote:
-->

Hi all,

 

I am running postgres 7.4.2 on a Dual processor Opteron with 16GB of ram. I want to set shared_buffers to a large value, but I am running into startup problems.

 

I have set my kernel SHMMAX and SHMALL to 12GB.

 

When I set shared_buffers to a value which puts the total shared memory usage over 1GB, my postgres server fails to start. Unfortunatly, I also cannot seem to get any logfile output out of my system (perhaps another question).

 

Are there any hardcoded max values for shared_buffers? I noticed in the code that a uint32 is used for the page size which would mean a 4GB max. This is failing at much lower values.

 

Sorry that I do not have a logfile output. Perhaps someone could help me turn my logfile on. I am passing –l logfile at startup, but my logfile remains empty.

 

Thanks in advance

 

Barry

(barry@GeipelNet.com



-- 
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL

pgsql-general by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: Data Encryption in PostgreSQL, and a Tutorial.
Next
From: Tom Lane
Date:
Subject: Re: Problems setting shared_buffers to large value