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 5395454517 for ; Sun, 1 May 2005 23:13:44 -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 10217-01 for ; Mon, 2 May 2005 02:13:43 +0000 (GMT) Received: from host10.globalnameservers.com (host10.globalnameservers.com [209.239.41.145]) by svr1.postgresql.org (Postfix) with ESMTP id C906F53794 for ; Sun, 1 May 2005 23:13:41 -0300 (ADT) Received: from medinomics.com (localhost [127.0.0.1]) by host10.globalnameservers.com (8.12.10/8.12.10) with ESMTP id j422DdO0027172 for ; Sun, 1 May 2005 22:13:39 -0400 From: "sv" To: pgsql-admin@postgresql.org Subject: Getting Started Basic Admin Date: Sun, 1 May 2005 21:13:39 -0500 Message-Id: <20050502021339.M43779@medinomics.com> X-Mailer: Open WebMail 1.81 20021127 X-OriginatingIP: 65.0.14.161 (sv) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200505/80 X-Sequence-Number: 17509 Hello, I am very confused. I have a Debian server with PostGreSQL running. I have everything installed and working. Here is my wish list: 1. To do anything, I have to "su - postgres". This has no password. How do I put a password on it. I have tried "passwd postgres wackypass" but it did not work. 2. How do I add new users? When I add a regular user account in Linux does it add a Postgres user automatically? I tried "createuser" and it works but I can't login as that user in phpPgAdmin (front page login). Once I login with the "false" security (see Question 3), I see all the users I added with "createuser". 3. With phpPgAdmin, I can login because i turned "extra_login_security" to false... not very secure. How does this relate to the adduser (Linux account) and/or "createuser". I am sorry about the questions. I have spent hours reading and piecing together posts to try to reverse into my answers but have had no luck. Thank you in advance, Stephen