Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 296C8474E50 for ; Tue, 6 Aug 2002 19:22:24 -0400 (EDT) Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id A3A6E474E44 for ; Tue, 6 Aug 2002 19:22:23 -0400 (EDT) Received: by news.hub.org (Postfix, from userid 8) id DAF6538195E; Tue, 6 Aug 2002 19:21:51 -0400 (EDT) From: Lee Harr X-Newsgroups: comp.databases.postgresql.admin Subject: Re: Installing Postgres Date: Tue, 6 Aug 2002 23:21:51 +0000 (UTC) Organization: Hub.Org Networking Services (http://www.hub.org) Lines: 19 Message-ID: References: Reply-To: missive@hotmail.com X-Complaints-To: news@hub.org User-Agent: slrn/0.9.7.3 (FreeBSD) To: pgsql-admin@postgresql.org X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/65 X-Sequence-Number: 5180 In article , Mauro wrote: > Hi, > > I'm having problems with users authentication in Postgres with linux. > I have a user postgres and others. If in my pg_hba.conf I put > passsword in AUTH_TYPE no users can log in with a message of > authentication failed for user 'username', if I put trust every user > log in without prompt of password and when I put crypt, again every > user log in without prompt of password. I stop and start postgresql > with no errors... > Do the users have passwords? Did you do something like: ALTER USER steve WITH PASSWORD 'ht6r&kww';