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 330F69DCA9B for ; Tue, 28 Mar 2006 13:41:14 -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 15370-10 for ; Tue, 28 Mar 2006 13:41:11 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from web30806.mail.mud.yahoo.com (web30806.mail.mud.yahoo.com [68.142.200.149]) by postgresql.org (Postfix) with SMTP id 3715E9DCA33 for ; Tue, 28 Mar 2006 13:41:08 -0400 (AST) Received: (qmail 88781 invoked by uid 60001); 28 Mar 2006 17:41:05 -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=GIBdpz8omssWbezgHT2bZ2PUCpiNzD7Za80sIfanjLObt2TtXdI8zwOFMx9M+pU7JvDnxgRfFz0yk3kcyzaSblTHh9CN73Tha1MgJ1/vCfW4YMt8A32XpV0+RaHiTw2850iXAKiwFJAnbn9aht1wVhAqZYCc24kcbN/mwVyojL4= ; Message-ID: <20060328174105.88779.qmail@web30806.mail.mud.yahoo.com> Received: from [67.175.142.230] by web30806.mail.mud.yahoo.com via HTTP; Tue, 28 Mar 2006 09:41:05 PST Date: Tue, 28 Mar 2006 09:41:05 -0800 (PST) From: lmyho Subject: Re: PostgreSQl newbie! -PLease help, pgAdmin3 on Debian! To: Richard Broersma Jr , pgsql-admin@postgresql.org In-Reply-To: <20060328130052.81125.qmail@web31801.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.527 required=5 tests=[AWL=0.169, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_WHOIS=0.879, MANY_EXCLAMATIONS=0] X-Spam-Score: 1.527 X-Spam-Level: * X-Archive-Number: 200603/310 X-Sequence-Number: 21067 Hi Rich, Thank you very much!! Have some further question: > 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". How should I do this? The current auto-generated pg_hba.conf file read as: "local all postgres ident sameuser" on the first line, and the first line also after the # TYPE DATABASE....METHOD line. Do you mean I should change the "ident sameuser" at the end to "trust"? > > Then you should be able to log into postgresql using "psql -U postgres -d > template1" Should I login by this way from command line? THANK YOU!! leo __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com