Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 3E30A475E22 for ; Tue, 1 Oct 2002 10:49:59 -0400 (EDT) Received: from mx9.mail.ru (mx9.mail.ru [194.67.57.19]) by postgresql.org (Postfix) with ESMTP id 1105F475B8C for ; Tue, 1 Oct 2002 10:49:57 -0400 (EDT) Received: from drweb by mx9.mail.ru with drweb-scanned (Exim MX.9) id 17wOLZ-00084K-00; Tue, 01 Oct 2002 18:50:01 +0400 Received: from [213.128.193.142] (helo=mail.ru) by mx9.mail.ru with esmtp (Exim SMTP.9) id 17wOLZ-0007zo-00; Tue, 01 Oct 2002 18:50:01 +0400 Message-ID: <3D99B615.1020504@mail.ru> Date: Tue, 01 Oct 2002 18:49:57 +0400 From: dima <_pppp@mail.ru> User-Agent: Mozilla/5.0 (X11; U; FreeBSD i386; en-US; rv:1.0.0) Gecko/20020816 X-Accept-Language: ru, en-us, en MIME-Version: 1.0 To: Lucas Brasilino Cc: pgsql-sql@postgresql.org Subject: Re: alter user does not changes password References: <3D99B53A.1020707@recife.pe.gov.br> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Envelope-To: brasilino@recife.pe.gov.br, pgsql-sql@postgresql.org X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/3 X-Sequence-Number: 9721 > alter user camara with password 'canabis!'; > > but when I try to connect: > > $ psql -U camara dbcamara; > > User "camara" logs with no password!!!! If I use -W option of psql > It prompts for password and I can enter whatever I want... it accepts! > > It must be a feature.. not a bug... I know I'm making a mistake.. > but.. where?? can you quote pg_hba.conf (without comments naturally) here?