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 616643A18D0 for ; Fri, 31 Dec 2004 09:59:52 +0000 (GMT) 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 99113-02 for ; Fri, 31 Dec 2004 09:59:46 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.194]) by svr1.postgresql.org (Postfix) with ESMTP id 115FA3A1A12 for ; Fri, 31 Dec 2004 09:59:47 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id a36so106484rnf for ; Fri, 31 Dec 2004 01:59:47 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=S6nDd6MYSXXtLMbxN5bGmpmVNzp1+ThsqyArBDhS5HU3hjnaPKCRFbSyCsrSQPTAsAJAZibHfh+1aC6BfWnO1cIE5plx4cgLfcSUpFI5RfbnRTpSqQ5O3uCkDUFEf6Nhqc0ep/fITYOGDn05ylsaDQwqgXZ2LXO5KigsJtstOn4= Received: by 10.39.3.47 with SMTP id f47mr344886rni; Fri, 31 Dec 2004 01:59:47 -0800 (PST) Received: by 10.38.163.25 with HTTP; Fri, 31 Dec 2004 01:59:47 -0800 (PST) Message-ID: Date: Fri, 31 Dec 2004 04:59:47 -0500 From: Henry Kon Reply-To: Henry Kon To: pgsql-admin@postgresql.org Subject: Re: initial windows install : can't createuser or createdb - what user / pass to use? In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 tagged_above=0 required=5 tests=RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200501/5 X-Sequence-Number: 15864 the initial admin user comes from the service installation screen. from this web site I just found. http://pginstaller.projects.postgresql.org/ HK On Fri, 31 Dec 2004 04:48:25 -0500, Henry Kon wrote: > I've just installed postgresql on windows version 8.0.0 rc-2 and am > trying to do very first things like createuser or createdb but all I > get is messages like: > > createuser: could not connect to database template1: FATAL: password > authentication failed for user "xxxxx" > > How do I add users or do other admin stuff at startup? Is there a > default administrative user and password that I should know about? > > From the example below, lbaigell is the user I log into windows with - > so Postgres knows about that user name by itself - the password I'm > trying to use is the windows password - a 6 alpha character string. > > Thank you > Henry > > interaction below: > > C:\Program Files\PostgreSQL\8.0.0-rc2\bin>createuser > Enter name of user to add: mkon > 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 > Password: > createuser: could not connect to database template1: FATAL: password > authentication failed for user "lbaigell" > > C:\Program Files\PostgreSQL\8.0.0-rc2\bin>c >