Re: PG 7.0.3 & RH 7 IPC problems?

Gracias, merci' & Thank You Tom!
After shutting down the entries were still there.
I rebooted and restarted and voila!, we're in business.

Tom Lane wrote:
>
> DHSC Webmaster <webmaster(at)dhs-club(dot)com> writes:
> > [root(at)atl01371 linux]# ipcs
>
> > ------ Shared Memory Segments --------
> > key shmid owner perms bytes nattch status
> > 0x0052e2ca 36864 postgres 700 144 5
> > 0x0052e2c1 26625 postgres 600 1104896 5
> > 0x0052e2c7 37890 postgres 600 66060 5
>
> > ------ Semaphore Arrays --------
> > key semid owner perms nsems status
> > 0x0052e2ce 6144 postgres 600 16
> > 0x0052e2cf 6145 postgres 600 16
>
> > ------ Message Queues --------
> > key msqid owner perms used-bytes messages
>
> > These values don't seem to change from one moment to the next although
> > there are of course varying numbers of backends running at any given
> > moment.
>
> These objects are created by the postmaster and persist as long as the
> postmaster does. They *should* go away when you shut down the
> postmaster, but perhaps they didn't for some reason.
>
> Anyway, I suggest (a) shut down postmaster, (b) use ipcs to make sure
> there are no postgres shmem or sema objects (delete 'em with ipcrm if
> necessary), and (c) try to start postmaster with new -B/-N values.
>
> If step (c) fails when there are no pre-existing objects, then it must
> be that you have not managed to increase the kernel's limits on shared
> memory. The exact incantations needed to accomplish that trick vary
> across systems, so I can't offer a lot of help there.
>
> regards, tom lane

--
Bill MacArthur
Webmaster
DHS Club