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
----------
pedro@pcporta16:~$ psql template1
Welcome to psql 7.4.2, 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
template1=> \du List of database usersUser name | User ID | Attributes
-----------+---------+----------------------------fpam | 101 | create databasepedro | 100 | create
databasepostgres | 1 | superuser, create database
(3 rows)
-----------
Any help will be appreciated, thank you.
--
Pedro Henrique e Figueiredo Quaresma de Almeida