Re: Starting postmaster error

Поиск
Список
Период
Сортировка
От GH
Тема Re: Starting postmaster error
Дата
Msg-id 20010130193140.A24495@over-yonder.net
обсуждение исходный текст
Ответ на Starting postmaster error  (Sebastian Mirolo <Sebastian.Mirolo@trimedia.com>)
Список pgsql-novice

One who most-definitely *is* a privileged user would have to alter the
system shared memory setup per the PostgreSQL docs.


gh

On Tue, Jan 30, 2001 at 05:07:09PM -0800, some SMTP stream spewed forth:
> Hi,
>
> I had no trouble installing postgresql, but when I try to launch the
> command
>
>  "/home/smirolo/benchmarks/pgsql/bin/postmaster -D
> /home/smirolo/benchmarks/pgsql/data"
>
> I get the error message :
>
> "IpcMemoryCreate: shmget failed (Invalid argument) key=5432001,
> size=1115136, permission=600
>   This type of error is usually caused by an improper
>   shared memory or System V IPC semaphore configuration.
>   For more information, see the FAQ and platform-specific
>   FAQ's in the source directory pgsql/doc or on our
>   web site at http://www.postgresql.org.
>   FATAL 1:  ShmemCreate: cannot create region"
>
> I looked into the FAQ and it looks like a common problem, because this
> question is answered by
>
> "You either do not have shared memory configured properly in your kernel
> or you need to enlarge the
>   shared  memory available in the kernel. The exact amount you need
> depends on your architecture and how
>   many buffers and backend processes you configure for the postmaster.
> For most systems, with default
>   numbers of buffers and processes, you need a minimum of ~1MB"
>
> My only problem now is still to find out how I make it work. I am
> running on a UltraSparc 10 with
> a Solaris 7 operating system. Unfortunately, I can't run as a privileged
> user.
> My goal is to be able to stick the output of the benchmarks I am running
> into a database so that it makes
> it easier to retrieve and understand how compiler flags affect
> performance.
>
>                                  Thank you,
>
>                                          Sebastien.
>
>
> --
> Sebastien Mirolo
> Architecture Design Engineer
> TriMedia technologies inc.,
> 1840 McCarthy Boulevard,
> Milpitas, CA 95035
> tel: (408) 922 4626
> email: smirolo@trimedia.com
>
>
>

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

Предыдущее
От: Sebastian Mirolo
Дата:
Сообщение: Starting postmaster error
Следующее
От: "Michael Miyabara-McCaskey"
Дата:
Сообщение: Queries against multi-million record tables.