Re: Starting postmaster error

From: GH <grasshacker(at)over-yonder(dot)net>
To: Sebastian Mirolo <Sebastian(dot)Mirolo(at)trimedia(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Starting postmaster error
Date: 2001-01-31 01:31:41
Message-ID: 20010130193140.A24495@over-yonder.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)trimedia(dot)com
>
>
>

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Michael Miyabara-McCaskey 2001-01-31 04:16:39 Queries against multi-million record tables.
Previous Message Sebastian Mirolo 2001-01-31 01:07:09 Starting postmaster error