Re: [GENERAL] PostgreSQL 6.4 problems on Linux. - Mailing list pgsql-general

From Oliver Elphick
Subject Re: [GENERAL] PostgreSQL 6.4 problems on Linux.
Date
Msg-id 199811062230.WAA02905@linda.lfix.co.uk
Whole thread Raw
In response to Re: [GENERAL] PostgreSQL 6.4 problems on Linux.  (Fabio Mancinelli <mancinel@univaq.it>)
List pgsql-general
Fabio Mancinelli wrote:
  >On Sat, 7 Nov 1998, Kevin Lo wrote:
  >
  >> % IpcMemoryCreate: shmget failed (Invalid argument) key=543200
  >> 1, size=831176, permission=600
  >> FATAL 1:  ShmemCreate: cannot create region
  >>
  >If I am not wrong shmem has to do with X shared memory extension from MIT.
  >Probably you try to run postgres not on the host you are logged on.
  >I've seen that postgres can be compiled with X support. Try to disable it.
  >
  >Bye
  >
  >P.S. : Probably I am completely wrong! :)

I think so...  I am able to start the postmaster with -i in Linux 2.0.34.

The error '(Invalid argument)' is presumably from the kernel:

From the kernel code:
        if (size > shp->shm_segsz)
                return -EINVAL;

This bit of code is run if an existing shared memory segment is found;
so the problem seems to be that the segment found is too small for the
request made of it.

I suggest that he use ipcrm to clear shared memory segments and then try
again.

One puzzle for me is that ipcs does not report any shared memory in use,
even with two backends using the same database.  I thought shared memory
was used to do locking??

(This may be to do with the fact that I am not running my normal kernel
version at the moment.)
--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight                              http://www.lfix.co.uk/oliver
               PGP key from public servers; key ID 32B8FAA1
                 ========================================
     "Let all that you do be done in love."
                                      1 Corinthians 16:14



pgsql-general by date:

Previous
From: Dustin Sallings
Date:
Subject: max(), datetimes, and indexes
Next
From: Kevin Lo
Date:
Subject: Re: [GENERAL] PostgreSQL 6.4 problems on Linux.