I see this all the time. try lowering the number of processes allowed
with the -N switch. 32 is default. example: -N 8 -B 16. See if it works
better. If it does, try to increase the memsize of shared memory. Check
the list archive; I think there's been a discussion around this for
Solaris.
/Palle
Unprivileged user wrote:
>
> ============================================================================
> POSTGRESQL BUG REPORT TEMPLATE
> ============================================================================
>
> Your name : Deon Ramsey
> Your email address : miavir@furry.de
>
> Category : install: other
> Severity : critical
>
> Summary: Postmaster bombs with shared memory error
>
> System Configuration
> --------------------
> Operating System : Solaris 2.6 HW 5/98 Desktop
>
> PostgreSQL version : 6.5
>
> Compiler used : egcs-1.1.1
>
> Hardware:
> ---------
> Ooops, forgot to add this last time, so am repeating.
> I'm on a Sun Sparc Classic, uname -a gives:
> SunOS altair 5.6 Generic_105181-12 sun4m sparc SUNW,SPARCclassic
>
> Versions of other tools:
> ------------------------
> gnmake3.77
> flex2.5.4
>
> --------------------------------------------------------------------------
>
> Problem Description:
> --------------------
> postmaster -i reports:
> IpcMemoryCreate: shmget failed (Invalid argument) key=5432001, size=1073152, permission=600
> FATAL 1: ShmemCreate: cannot create region
>
> It might be of interest to note that flex reported errors in building
> pl_parse.o , but the whole make came back with 'All of PostgreSQL is successfully made. Ready to install.'
>
> --------------------------------------------------------------------------
>
> Test Case:
> ----------
> Just compile the program and install as per instructions, then initdb and try postmaster -i
>
> --------------------------------------------------------------------------
>
> Solution:
> ---------
>
> --------------------------------------------------------------------------