Re: More "IpcMemoryCreate: shmget failed" errors

On Fri, 16 Jun 2000, The Hermit Hacker <scrappy(at)hub(dot)org> wrote:

>
> Okay, my first question is is *what* OS are you running on? I get this
> sort of error under Solaris if I use a defautl install of both the OS and
> PostgreSQL, and have to use the -B option to reduce the number of segments
> that PostgreSQL wants to configure ...

Sorry for not including the OS to all those who replied to me ...
I guess I thought people would refer back to my original post which was
submitted using the standard template :/ Apologies...

I am running Linux 2.0.38 on an Intel Pentium 133Mhz.

> v6.5.3, I believe it was, changed the IPC usage so that it allocates all
> it needs when you start, vs growing as required, so that it pre-allocates
> ... so if you were using a pre-"this code" version and moving up, this
> might be triggering your problem ...

The machine used to run 6.5.3. I then attempted an upgrade to
7.0.0 and started to get these "IpcMemoryCreate: shmget failed" errors. I
then tried 7.0.2 and the errors continued. I then tried to revert back to
6.5.3 and got more "IpcMemoryCreate: shmget failed" errors.

On Fri, 16 Jun 2000, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> Have you done any actual investigation --- like looked at the output
> of ipcs -m -a to see whether there are old segments lying around?

I've never really messed with ipcs (and any of its family)
before ... I'm just trying to upgrade the installation and am meeting
problems. I am investigating the use of ipcs (and its family) on a devel
machine before I move onto 'playing' with shared memory on the production
box.

> The ipcclean script is not very bright, and in particular I doubt it
> knows about all the formats that different platforms' versions of
> ipcs produce. So it may just be failing to recognize what has to be
> removed.
>
> The "Permission denied" error suggests that you may be trying to run
> Postgres under a different userid than you were before. If so, you'll
> have to delete the old segments as that other user, or as root.

PostgreSQL 6.5.3 ran under user postgres beforehand, and
7.0.0/7.0.2 is also being ran under user postgres.

On Fri, 16 Jun 2000, Ronald Kuczek <ronald(at)breitenbach-it(dot)de> wrote:

> Hi !
> And your OS ?
> Sorry, I did't followed your story. If you tell me, I can help you.

[Covered above]

Thanks to all who replied, your help is greatly appreciated.

--
Sean Kelly <S(dot)Kelly(at)ncl(dot)ac(dot)uk>
"The best way to predict the future is to invent it" - Alan Kay