Re: initdb fails

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, pandurangan(dot)r(dot)s(at)gmail(dot)com
Subject: Re: initdb fails
Date: 2005-12-07 19:27:07
Message-ID: 2380.1133983627@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:
> However, when the server SHMMAX is smaller than the size required
> by the defaults for shared_buffers and max_connections, I have
> not been able to find a way (other than the above), to tell
> initdb to use a nondefault values.

Well, initdb is just a shell script in 7.4, so it's not that hard
to edit it to try even-smaller values for max_connections and/or
shared_buffers. I stand by my comment that performance is going to
suck though, and you may even run into "out of buffers" failures.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Simon Riggs 2005-12-07 20:28:48 Re: initdb fails
Previous Message Anne M. Hammond 2005-12-07 18:04:24 Re: initdb fails