X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 2DFBBD1D27F for ; Mon, 16 Feb 2004 17:24:31 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 09524-07 for ; Mon, 16 Feb 2004 13:24:27 -0400 (AST) Received: from front3.netvisao.pt (front3.netvisao.pt [213.228.128.91]) by svr1.postgresql.org (Postfix) with SMTP id 28DBED1D25D for ; Mon, 16 Feb 2004 13:24:17 -0400 (AST) Received: (qmail 7549 invoked by uid 103); 16 Feb 2004 17:40:39 -0000 Received: from unknown (HELO front4.netvisao.pt) (213.228.128.143) by front3.netvisao.pt with SMTP; 16 Feb 2004 17:40:39 -0000 Received: (qmail 7334 invoked by uid 503); 16 Feb 2004 17:25:17 -0000 Received: from unknown (HELO netvisao.pt) (217.129.101.229) by mail.netvisao.pt with SMTP; 16 Feb 2004 17:25:17 -0000 Message-ID: <4030FCBF.2020005@netvisao.pt> Date: Mon, 16 Feb 2004 17:24:15 +0000 From: Pedro Almeida User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040124 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: pgsql initial superuser Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/238 X-Sequence-Number: 12412 Hello. this is my "first" time using pgsql, and I seem to be running to a bit of a corner here :-) I've understood how to add a superuser/database-user/user but I have no user to begin with. ~# createuser superuser Shall the new user be allowed to create databases? (y/n) y Shall the new user be allowed to create more new users? (y/n) y psql: FATAL: user "root" does not exist createuser: creation of user "superuser" failed So I need someway to add a user so I can add others. I belive this is done in the pg_hba.conf file, but so far I've been unlucky. I'm using the debian distributed pg_hba.conf file set up for local access, and I tried the following lines, each a complete failure: pg_hba.conf local all root md5 #OR #local all root ident Even with "createuser blabla -Uroot -W" and using the "ident" auth method fails. What am I missing here? Thank you for the support :-D