I use Debian. In one example (with user postgres) i obtain success:
sh-3.00$ psql -l
Listado de base de datos
Nombre | Dueño | Codificación
-----------+----------+--------------
mydb | postgres | SQL_ASCII
template0 | postgres | SQL_ASCII
template1 | postgres | SQL_ASCII
test | postgres | SQL_ASCII
(4 filas)
The problem appears when i use tora or pgaccess, i can't connect to db.
The message is:
Unable to connect to the database.
FATAL: IDENT authentication failed for user "portgres"
Who/where is the possible problem?
I try:
user: postgres
pass: "mypass"
port: 5432
localhost
db: mydb
Any answer?