Re: problems in connecting to a server

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