[gull] User PostgreSQL sous RH8.0
florian at salamin.net
florian at salamin.net
Thu Dec 18 08:54:02 CET 2003
Bonjour,
Je souhaite créer 2 utilisateurs PostgreSQL sur une machine RedHat 8.0
(voir extrait de log ci-dessous).J'ai motifié le fichier pg_hba.conf pour permettre la connexion au serveur
avec un loginname indépendant du compte utilisateur utilisé.Même apres un
-bash-2.05b$ pg_ctl reload
il m'est impossible de me loguer avec un compte utilisateur.
Est-ce que quelqu'un à une piste à me donner car là, je suis en train de
sécher :(
Merci,
Florian
--->8---
-bash-2.05b$ whoami
postgres
-bash-2.05b$ createuser -W safl_dbo
Shall the new user be allowed to create databases? (y/n) n
Shall the new user be allowed to create more new users? (y/n) y
Password:
CREATE USER
-bash-2.05b$ createuser -W safl_user
Shall the new user be allowed to create databases? (y/n) n
Shall the new user be allowed to create more new users? (y/n) n
Password:
CREATE USER
-bash-2.05b$ tail /usr/local/pgsql/data/pg_hba.conf
#local all trust
#host all 127.0.0.1 255.255.255.255 trust
# Using sockets credentials for improved security. Not available everywhere,
# but works on Linux, *BSD (and probably some others)
# TYPE DATABASE IP_ADDRESS MASK AUTH_TYPE
AUTH_ARGUMENTlocal all all trust
#local all ident
sameuser-bash-2.05b$ createdb test
CREATE DATABASE
-bash-2.05b$ psql test
Welcome to psql, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help on internal slash commands
\g or terminate with semicolon to execute query
\q to quit
test=# \q
-bash-2.05b$ psql -W -U safl_dbo -d test
Password:
psql: FATAL 1: IDENT authentication failed for user "safl_dbo"
-bash-2.05b$ psql -W -U safl_user -d test
Password:
psql: FATAL 1: IDENT authentication failed for user "safl_user"
-bash-2.05b$ uname -a
Linux casa 2.4.18-14 #1 Wed Sep 4 13:35:50 EDT 2002 i686 i686 i386 GNU/Linux
-bash-2.05b$ cat /etc/issue
Red Hat Linux release 8.0 (Psyche)
Kernel \r on an \m
-bash-2.05b$
--->8---
More information about the gull
mailing list