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
In response to
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 Perlstein||Date: 2001-03-29 19:57:30|
|Subject: Re: [ADMIN] Re: Re: [PORTS] pgmonitor and Solaris|