Re: [GENERAL] pg_hba.conf and crypt

Oliver Elphick wrote:

> This is a document I wrote some time ago on this subject.  If any parts of
> it are no longer accurate, please let me know.
>
> ====================================
> How to use clear or encrypted passwords for PostgreSQL access:
> =============================================================
>
> Use lines such as
>
>   local         all                             password
>   host          192.137.23      255.255.255.0   crypt
>
> in /etc/postgresql/pg_hba.conf; then you can use
>
>    CREATE USER user WITH PASSWORD password...
>
> to create a new user with the specified password, or
>
>    ALTER USER user WITH PASSWORD password...
>
> to change the password of an existing user.  ANY USER with create-user
> privilege can ALTER a password for any user, *INCLUDING* the postgres
> super-user.
>
> If connecting with psql, use the -u option; the user is prompted for username
> and password.  If you don't use -u, the connection fails.

Hi, Oliver,

I follow your instructions to do on my local machine, edit the file
pg_hba.conf:

local        all                                         password
host         all   127.0.0.1     255.255.255.255         crypt

then I connect with psql, use the -u option, I got the following errors:

% psql -u
Username: postgres
Password:

User authentication failed
Connection to database 'postgres' failed.
User authentication failed

If I don't edit the file pg_hba.conf, I can connect template1
with no problem. I have run createuser and have created the user 'postgres'.
Would you like to tell me how to solve this problem, thanks.

-Kevin.