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 4790ED1DA83 for ; Mon, 16 Feb 2004 18:43:32 +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 48775-01 for ; Mon, 16 Feb 2004 14:43:28 -0400 (AST) Received: from front3.netvisao.pt (front3.netvisao.pt [213.228.128.91]) by svr1.postgresql.org (Postfix) with SMTP id 2B551D1D69B for ; Mon, 16 Feb 2004 14:43:25 -0400 (AST) Received: (qmail 4584 invoked by uid 103); 16 Feb 2004 18:59:47 -0000 Received: from unknown (HELO front4.netvisao.pt) (213.228.128.143) by front3.netvisao.pt with SMTP; 16 Feb 2004 18:59:47 -0000 Received: (qmail 4356 invoked by uid 503); 16 Feb 2004 18:44:26 -0000 Received: from unknown (HELO netvisao.pt) (217.129.101.229) by mail.netvisao.pt with SMTP; 16 Feb 2004 18:44:25 -0000 Message-ID: <40310F4B.7010800@netvisao.pt> Date: Mon, 16 Feb 2004 18:43:23 +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: Re: 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/240 X-Sequence-Number: 12414 kaolin fire wrote: > try user 'pgsql' :) that's the default initially created superuser, no > password (it would be good to give it one). > > -kaolin fire > -http://erif.org/code/fallingup/ for a 'spin' on tetris > > That was a quick response :-) using a clean pg_hba.conf file (no user lines added), this is what happened: ******* ~# createuser -Upgsql Enter name of user to add: blabla Shall the new user be allowed to create databases? (y/n) n Shall the new user be allowed to create more new users? (y/n) n psql: FATAL: IDENT authentication failed for user "pgsql" createuser: creation of user "blabla" failed ******* What am I doing wrong ?