Re: Identity Problem

It looks as though you need to create your database users.

Try using the "createuser" command.

For more information:
http://www.postgresql.org/docs/7.4/interactive/user-manag.html

Eddy


Mike-Olumide Johnson wrote:
> Hello,
>
> Have RADIUS setup and working properly.
>
> While executing SQL got the following error:
>
> 'psql: Warning: The -u option is deprecated. Use -U. User name: Password:
> /root/freeradius-1.0.1/src/modules/rlm_sql/drivers/rlm_sql_postgresql/db_pos
> tgresql.sql: Permission denied'
>
> Below is further ouputs from CLI
>
> root@mj data]# psql -U
> psql: option requires an argument -- U
> Try 'psql --help' for more information.
> [root@mj data]# psql -u
> psql: Warning: The -u option is deprecated. Use -U.
> User name: root
> Password:
> psql: FATAL:  Database "root" does not exist in the system catalog.
> [root@mj data]# psql -u
> psql: Warning: The -u option is deprecated. Use -U.
> User name: postgres
> Password:
> psql: FATAL:  IDENT authentication failed for user "postgres"
>
> Will appreciate if someone can point me to how this problem could be
> resolved.
>
> Thanks in anticipation,
> Mike
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>