X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id B137B9DCABC for ; Tue, 28 Mar 2006 09:00:51 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 37568-05 for ; Tue, 28 Mar 2006 09:00:54 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web31801.mail.mud.yahoo.com (web31801.mail.mud.yahoo.com [68.142.207.64]) by postgresql.org (Postfix) with SMTP id 40FD79DCA92 for ; Tue, 28 Mar 2006 09:00:49 -0400 (AST) Received: (qmail 81127 invoked by uid 60001); 28 Mar 2006 13:00:52 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=6i0uKDcsdq0iikYJcmexG8bQ+erUEEN3+TtmjlACH2RRDHFkhu0VK6IwgHnvKigWYZYjGDQt2hnIjd+nGVhW7AE+5beyLzXaAsd9oSfGEkABbA/slyP6Hf3aazwtOXOOv6Hegu4CrYbibR3W8K4CirJfmLZoCZvfBA88IFL2CuE= ; Message-ID: <20060328130052.81125.qmail@web31801.mail.mud.yahoo.com> Received: from [68.235.218.116] by web31801.mail.mud.yahoo.com via HTTP; Tue, 28 Mar 2006 05:00:52 PST Date: Tue, 28 Mar 2006 05:00:52 -0800 (PST) From: Richard Broersma Jr Subject: Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian! To: lmyho , pgsql-admin@postgresql.org In-Reply-To: <20060328070807.65298.qmail@web30812.mail.mud.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.138 required=5 tests=[AWL=-0.220, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_WHOIS=0.879, MANY_EXCLAMATIONS=0] X-Spam-Score: 1.138 X-Spam-Level: * X-Archive-Number: 200603/303 X-Sequence-Number: 21060 Please can anyone help me here? I've been so frustrated.:( If there is auto-created password > for this auto-created postgres user, please anyone tell me what it is?? And also otherwise, how > can I log-in using the "ident auth" method?? If you just getting started with postgresql you will want to change the user postgres ident to "trust". Then you should be able to log into postgresql using "psql -U postgres -d template1" There you can change the postgres db-user password with alter user postgres password 'password'; once completed then log out using "\q" Now if you wanted to change you ident method back to md5 you will be able to use you new password. This should work, but you would probably be better server by following the directions in the postgresql documentation. Regards, Richard Broersma Jr.