Identity Problem - Mailing list pgsql-general

From Mike-Olumide Johnson
Subject Identity Problem
Date
Msg-id 024601c507b8$8daa91f0$5600a8c0@sysadmin
Whole thread Raw
In response to ANNOUNCE: ShellSQL 0.7  (Edward Macnaghten <eddy@edlsystems.com>)
Responses Re: Identity Problem  (Edward Macnaghten <eddy@edlsystems.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Postgresql and Athlon64 ?
Next
From: Tom Lane
Date:
Subject: Re: Dereferencing a 2-dimensional array in plpgsql