Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id EB3679FA0FB for ; Thu, 7 Dec 2006 10:34:44 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-new, port 10024) with ESMTP id 85390-03 for ; Thu, 7 Dec 2006 10:34:40 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from ns1.peker.com.pl (181-ego-2.acn.waw.pl [62.121.85.181]) by postgresql.org (Postfix) with SMTP id D7F129F9F46 for ; Thu, 7 Dec 2006 10:34:36 -0400 (AST) Received: (qmail 21340 invoked by uid 540); 7 Dec 2006 14:25:15 -0000 Received: from 153.19.179.26 by ns1.peker.com.pl (envelope-from , uid 401) with qmail-scanner-1.25st (clamdscan: 0.82/760. spamassassin: 3.0.2. perlscan: 1.25st. Clear:RC:1(153.19.179.26):. Processed in 0.07885 secs); 07 Dec 2006 14:25:15 -0000 Received: from rzgw.artnet.pl (HELO ?10.4.128.107?) (informatyka-adamr@153.19.179.26) by ns1.peker.com.pl with SMTP; 7 Dec 2006 14:25:15 -0000 Message-ID: <457825DB.3060503@informatyka.gdansk.pl> Date: Thu, 07 Dec 2006 15:31:55 +0100 From: Adam Radlowski User-Agent: Mozilla Thunderbird 1.0.6 (X11/20050716) X-Accept-Language: pl, en-us, en MIME-Version: 1.0 To: ankit.mehrotra@tcs.com CC: pgsql-admin@postgresql.org Subject: Re: problem in logging into database References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/45 X-Sequence-Number: 23837 Did You specified the database ? In PostgreSQL You are logging into database, not into DBMS, like in MySQL. For test users try template1 first, for example psql -h yourhost -U somebody -d template1 Did You grant those users rights to database wchich they are connecting to ? Regards Adam ankit.mehrotra@tcs.com wrote: > > > I am new to using postgres. I working on version 8.0. > > I have created a number of users in the database but I am not able to > log into it using any of them, where in logging into using user > postgres is successfull .... the commands that i am using are > > -- createuser -a -d -P "username" > > for logging into , i am using > -- psql -U "username" > > In all the references online, it says that the process shud work. > The postmaster service and databases are running. > > >=====-----=====-----===== >Notice: The information contained in this e-mail >message and/or attachments to it may contain >confidential or privileged information. If you are >not the intended recipient, any dissemination, use, >review, distribution, printing or copying of the >information contained in this e-mail message >and/or attachments to it are strictly prohibited. If >you have received this communication in error, >please notify us by reply e-mail or telephone and >immediately and permanently delete the message >and any attachments. Thank you > > > >