From: | "Barry L(dot) Geipel" <barry(at)GeipelNet(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Problems setting shared_buffers to large value |
Date: | 2004-04-12 22:24:45 |
Message-ID: | 200404122118.i3CLItg04056@GeipelNet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)GeipelNet(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | scott.marlowe | 2004-04-12 22:35:29 | Re: Data Encryption in PostgreSQL, and a Tutorial. |
Previous Message | Tom Lane | 2004-04-12 22:05:30 | Re: Data Encryption in PostgreSQL, and a Tutorial. |