Re: initdb fails

Поиск
Список
Период
Сортировка
От Pandurangan R S
Тема Re: initdb fails
Дата
Msg-id 5e744e3d0512070119l6fb52eaao765d54277838f62f@mail.gmail.com
обсуждение исходный текст
Ответ на initdb fails  ("Anne M. Hammond" <hammond@solarz.Colorado.EDU>)
Список pgsql-admin
Hi,

The following link will help you

http://www.powerpostgresql.com/Downloads/annotated_conf_80.html

On 12/7/05, Anne M. Hammond <hammond@solarz.colorado.edu> wrote:
> This is running on a Solaris 8 machine.
>
> I installed V 7.4.7 to use with OpenACS.
>
> lcd[34]% /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data
> ...
> selecting default max_connections... 10
> selecting default shared_buffers... 50
> creating configuration files... ok
> creating template1 database in /usr/local/pgsql/data/base/1... FATAL:
> could not create shared memory segment: Invalid argument
> DETAIL:  Failed system call was shmget(key=1, size=1081344, 03600).
> ...
>
> lcd[36]% sysdef -i | grep SHMMAX
>    1048576 max shared memory segment size (SHMMAX)
>
> -----------
> 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.
>
> But initdb -D /usr/local/pgsql/data
> finds that the directory is not empty and will not create the databases.
> I have also tried
> setenv PGOPTIONS="shared_buffers = 24"
> and tried initdb, but initdb uses the default number.
>
> Could you tell me how to set shared_buffers from the default so
> that a smaller shared memory segment will be requested?
>
> If you could also tell me how to set the max_connections to a value
> different from the default, that would be great.
>
> Any advice appreciated.
>
> Anne Hammond, University of Colorado at Boulder
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
>                http://www.postgresql.org/docs/faq
>


--
Regards
Pandu

В списке pgsql-admin по дате отправления:

Предыдущее
От: "Anne M. Hammond"
Дата:
Сообщение: initdb fails
Следующее
От: "sandhya"
Дата:
Сообщение: reg:file transfer error