Return-Path: owner-postman Received: from localhost (localhost [127.0.0.1]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with SMTP id OAA23680 for postgres-dist; Mon, 28 Mar 1994 14:02:56 -0800 Resent-From: POSTGRES mailing list Resent-Message-Id: <199403282202.OAA23680@nobozo.CS.Berkeley.EDU> Sender: owner-postman@postgres.Berkeley.EDU X-Return-Path: owner-postman Received: from faerie.CS.Berkeley.EDU (faerie.CS.Berkeley.EDU [128.32.149.14]) by nobozo.CS.Berkeley.EDU (8.6.4/8.6.3) with ESMTP id OAA23671 for ; Mon, 28 Mar 1994 14:02:56 -0800 Received: from localhost (localhost [127.0.0.1]) by faerie.CS.Berkeley.EDU (8.6.4/8.1B) with SMTP id OAA27972; Mon, 28 Mar 1994 14:02:54 -0800 Message-Id: <199403282202.OAA27972@faerie.CS.Berkeley.EDU> X-Authentication-Warning: faerie.CS.Berkeley.EDU: Host localhost didn't use HELO protocol From: aoki@postgres.Berkeley.EDU (Paul M. Aoki) To: postgres@postgres.Berkeley.EDU Subject: Re: postgres & root Reply-To: aoki@postgres.Berkeley.EDU (Paul M. Aoki) In-reply-to: Your message of Mon, 28 Mar 1994 10:26:21 -0800 <199403281826.KAA23468@newberry.uoregon.edu> Date: Mon, 28 Mar 94 14:02:54 -0800 X-Sender: aoki@postgres.Berkeley.EDU Resent-To: postgres-dist@postgres.Berkeley.EDU X-Mts: smtp Resent-Date: Mon, 28 Mar 94 14:02:56 -0800 Resent-XMts: smtp > I'm the guilty party Ken Dueker at U of Oregon implied to you for running > postmaster under root - Postmaster fails to get shared memory allocated when > running as postgres. error message is IpcMemoryAttach: shmat failed: permis sion > denied. i should add that the usual reason for the postmaster being unable to free shared memory when it dies is the use of "kill -9" or "kill -KILL". in the 4.2 doc i tried to dissuade people from using "kill -9" for this reason. just plain "kill" works fine; the postmaster catches the signal and frees the shared resources before calling exit(2). if you use SIGKILL, it can't do that. -- Paul M. Aoki | CS Div., Dept. of EECS, UCB | aoki@postgres.Berkeley.EDU | Berkeley, CA 94720 | ...!uunet!ucbvax!aoki