X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 173E13A617C for ; Fri, 14 Jan 2005 00:22:16 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 58168-06 for ; Fri, 14 Jan 2005 00:22:06 +0000 (GMT) Received: from 3times25.net (66-23-211-34.clients.speedfactory.net [66.23.211.34]) by svr1.postgresql.org (Postfix) with ESMTP id 0A1323A63B7 for ; Fri, 14 Jan 2005 00:22:08 +0000 (GMT) Received: from [127.0.0.1] (rhws.home.edu [127.0.0.1]) by 3times25.net (Postfix) with ESMTP id 7BDA0748D3 for ; Thu, 13 Jan 2005 19:22:07 -0500 (EST) Message-ID: <41E710AE.1040305@3times25.net> Date: Thu, 13 Jan 2005 19:22:06 -0500 From: Geoffrey User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.2) Gecko/20040803 X-Accept-Language: en-us, en MIME-Version: 1.0 To: PostgreSQL Admin Subject: Re: Installing PostgreSQL as "postgress" versus "root" References: In-Reply-To: Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.034 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200501/135 X-Sequence-Number: 15994 Tomeh, Husam wrote: > > Wouldn't installing postgreSQL as postgres give me the convenience to > upgrade PostgreSQL and the database without having the SA get involved. > Is it a question of roles now? Should a DBA perform all > postgreSQL-related tasks or should that the accountability be confused > by having SA responsible for some DB tasks such as the installation and > upgrades and the DBA responsible for the rest.. What do you think? So then you open the possibility of a different person installing every software package. No, I think not. The sys admin should be aware of all installed software and changes. What happens when you install a particular package that requires, say N semaphores, but the kernel doesn't have it to give? Or worse, the app takes those sems while another package that's been installed, uses sems on and off, and suddenly does not have the sems it has always had? Now you're looking at this package having a problem where as the problem was created by the installation/upgrade of another package. The sys admin should be involved to some extent in all software installations. -- Until later, Geoffrey