Em Terça, 11 de Maio de 2004 10:25, Pedro Quaresma de Almeida escreveu:
> Hi
>
>I have two Debian systems, both with
>
> psql (PostgreSQL) 7.4.2
> pgadmin3 1.0.2
>
> but in one of them (the laptop) I am unable to make a connection with
> pgadmin3, I always get:
>
> ----------
> 2004-05-11 10:13:12 ERROR : Error connecting to the server: FATAL: IDENT
> authentication failed for user "pedro"
> ----------
>
> The "pedro" user has been created previously with the "createuser" command
>
With the debug output option on I get:
---------------
2004-05-11 13:46:58 INFO : Creating pgConn object
2004-05-11 13:46:58 INFO : Server name: localhost (resolved to: 127.0.0.1)
2004-05-11 13:46:58 INFO : Opening connection with connection string:
hostaddr=127.0.0.1 dbname=template1 user=pedro port=5432
2004-05-11 13:46:58 STATUS : Connecting to database without password... (0,01
segundos)
2004-05-11 13:46:58 ERROR : Error connecting to the server: FATAL: IDENT
authentication failed for user "pedro"
2004-05-11 13:46:59 INFO : Destroying pgConn object
----------------
my "/var/lib/postgres/data/pg_hba.conf" file has in it the lines
# All other connections by UNIX sockets
local all all ident sameuser
The user "pedro" is a valid Unix and PostgreSQL user.
???
Any help will be appreciated, thank you.
--
Pedro Henrique e Figueiredo Quaresma de Almeida
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
