Skip site navigation (1) Skip section navigation (2)

Re: PG 7.0.3 & RH 7 IPC problems?

From: DHSC Webmaster <webmaster(at)dhs-club(dot)com>
To:
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: PG 7.0.3 & RH 7 IPC problems?
Date: 2001-03-29 20:44:31
Message-ID: 3AC39EAF.59B12C20@dhs-club.com (view raw or flat)
Thread:
Lists: pgsql-admin
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

In response to

Responses

pgsql-admin by date

Next:From: Patrice HédéDate: 2001-03-29 21:00:47
Subject: Re: search on accents -> Why not include this function
Previous:From: Alfred PerlsteinDate: 2001-03-29 19:57:30
Subject: Re: [ADMIN] Re: Re: [PORTS] pgmonitor and Solaris

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group