| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Anne M(dot) Hammond" <hammond(at)lcd(dot)Colorado(dot)EDU> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: initdb fails |
| Date: | 2005-12-07 14:35:19 |
| Message-ID: | 28800.1133966119@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"Anne M. Hammond" <hammond(at)lcd(dot)Colorado(dot)EDU> writes:
> So the shared memory request is greater than the SHMMAX in
> the kernel. If I just wanted to use a smaller number of shared_buffers
> (24), I tried editing /usr/local/pgsql/data/pgsql.conf.
You're going to have to increase SHMMAX anyway, so you might as well
just do that, rather than trying to outflank initdb. PG's performance
with any less than several hundred shared buffers is just too awful to
consider using.
I haven't done this on Solaris personally, but according to our docs
http://www.postgresql.org/docs/7.4/static/kernel-resources.html
it's just a matter of editing /etc/system and rebooting.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-12-07 15:15:30 | Re: reg:file transfer error |
| Previous Message | Diego | 2005-12-07 12:46:38 | Checkpoint... |