Re: Installing Postgres

From: Lee Harr <missive(at)frontiernet(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Installing Postgres
Date: 2002-08-06 23:21:51
Message-ID: aiplme$1afd$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

In article <b5f11c7e(dot)0208051532(dot)7639f184(at)posting(dot)google(dot)com>, 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';

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Lee Harr 2002-08-06 23:32:42 Re: Automated database backups and authentication
Previous Message Murthy Kambhampaty 2002-08-06 22:17:27 Re: Automated database backups and authentication