Обсуждение: Starting postmaster error

Поиск
Список
Период
Сортировка

Starting postmaster error

От
Sebastian Mirolo
Дата:
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




Re: Starting postmaster error

От
GH
Дата:

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
>
>
>