Received: from post.webmailer.de (natpost.webmailer.de [192.67.198.65]) by postgresql.org (Postfix) with ESMTP id 07D164760B0 for ; Sun, 17 Mar 2002 11:32:59 -0500 (EST) Received: from eumel.yoo.net (p50859C52.dip.t-dialin.net [80.133.156.82]) by post.webmailer.de (8.9.3/8.8.7) with ESMTP id RAA29494 for ; Sun, 17 Mar 2002 17:33:03 +0100 (MET) Received: by eumel.yoo.net (Postfix on SuSE Linux 7.2 (i386), from userid 500) id 7772B1262C; Sun, 17 Mar 2002 17:43:50 +0100 (CET) Date: Sun, 17 Mar 2002 17:43:50 +0100 From: Thorsten Haude To: PostgreSQL Novice ML Subject: Re: create database, user Message-ID: <20020317164350.GA3928@eumel.yoo.net> Mail-Followup-To: PostgreSQL Novice ML References: <20020310182306.GS808@eumel.yoo.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.3.24i X-Warning: Email may contain unsmilyfied humor and/or satire. Keywords: Haschisch, Marihuana, Kokain, Heroin, LSD und Extacy sind alles Drogen Organization: Ministry of Information, Department of Information Adjustments X-Archive-Number: 200203/152 X-Sequence-Number: 3279 Hi, * Josh Berkus [02-03-10 20:16]: >> - I have still not grasped how I should connect to the DBMS for >> things >> like that; there is no root. Is there a document describing best >> practices somewhere? >First, read: http://www.postgresql.org/idocs/index.php?user-manag.html Done. >Your "root" user for PostgreSQL should be the user "postgres", unless > you have used a non-standard install. In a secure system, the > postgres user should belong to the group "daemon", own the pgsql/ > driectory tree, and have a secure password, both on the system and on > the database. The postgres user will also own the databases template1 > and template0. In a regular install, the postgres user will have > inhereted whatever passowrd it had on the host system. I think I understand the role of the template dbs, but why are there two of them? >This will give you a new database with wwwuser as its owner. wwwuser > will have full rights on all database objects. However, this is a not > terribly secure setup, and I wouldn't reccomend it for any public > website. Well, this will never reach the Internet, it is completely in-home. But since one of the purposes of this application is the learning effect, I'll follow your advice. >You may wish to subscribe to the pgsql-php or pgsql-perl mailing lists. I'll do that. Thank you! Thorsten -- There is no drug known to man which becomes safer when its production and distribution are handed over to criminals.