Skip site navigation (1) Skip section navigation (2)

Re: problems in connecting to a server

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 (view raw or flat)
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


In response to

pgadmin-support by date

Next:From: Andreas PflugDate: 2004-05-11 21:09:28
Subject: Re: bug report
Previous:From: Andreas PflugDate: 2004-05-11 11:09:53
Subject: Re: varchar[] !?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group