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 413D55341C for ; Wed, 11 May 2005 15:40:31 -0300 (ADT) 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 63159-06 for ; Wed, 11 May 2005 18:40:25 +0000 (GMT) Received: from gw1.psrc.org (unknown [209.102.90.61]) by svr1.postgresql.org (Postfix) with ESMTP id 6497B53319 for ; Wed, 11 May 2005 15:40:22 -0300 (ADT) Received: from PSRC-MTA by gw1.psrc.org with Novell_GroupWise; Wed, 11 May 2005 11:42:31 -0700 Message-Id: X-Mailer: Novell GroupWise Internet Agent 6.5.4 Date: Wed, 11 May 2005 11:42:03 -0700 From: "Brandon Fouts" To: Subject: security - user account setup on SUSE Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: quoted-printable Content-Disposition: inline X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.51 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200505/117 X-Sequence-Number: 17546 I think for security reasons I should not run PostgreSQL from the root = account. Also, as PostgreSQL will probably be only one of the applications running = on this box. (would running in UML give me any extra security? - I suspect not the = right tool??) IF I'm wrong to worry about root account, now is the time to inform me. = Otherwise read on. (I have setup once and I think I had it running from the root account.) background SUSE 9 and YAST install of PostgreSQL creates the following = directories: /usr/lib/postgresql/ /usr/share/postgresql/ /usr/share/pgsql/ /var/lib/pgsql/backup /var/lib/pgsql/data and currently status shows unused=20 # rcpostgresql status unused (rc - is this some kind of = scripting??) Can anyone offer some guidance? =20 =20