On Mon, Aug 18, 2003 at 20:11:41 +0300,
Aaron <aamehl@bezeqint.net> wrote:
> A friend of mine just wrote a database for me using postgres.
> I have postgres installed but can't figure out how to change the passwd
> for user postgres.
>
> [root@bzq-218-14-208 aamehl]# createdb -U postgres nigun_test
> psql: FATAL: IDENT authentication failed for user "postgres"
>
It looks like you aren't using password authentication.
One quick solution is to su to postgres before trying to connect to the
database.
Another is to change your pg_hba.conf and pg_ident.conf files to
allow specific system accounts to connect as the postgres database account.
A third option is to change pg_hba.conf to use one of the password
authentication methods instead of ident.