From: | Pedro Quaresma de Almeida <phfqa(at)netcabo(dot)pt> |
---|---|
To: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: problems in connecting to a server |
Date: | 2004-05-11 14:25:07 |
Message-ID: | 200405111525.08269.phfqa@netcabo.pt |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Pflug | 2004-05-11 21:09:28 | Re: bug report |
Previous Message | Andreas Pflug | 2004-05-11 11:09:53 | Re: varchar[] !? |