Hi, What is the authentication method for the local connections type ? Ident ? Change it to md5, restart postgres and try again. Regards. ------------------------------------------------------------------------------ On Thursday, 11 August, 2016 16:16:58 Andi Sugandi wrote:
Hi all,
I have postgresql-server and pgadmin installed on openSUSE Leap 42.1:
postgresql-devel-9.4-1.1.noarch postgresql-init-9.4-9.1.noarch postgresql94-9.4.6-4.1.x86_64 postgresql94-devel-9.4.6-4.1.x86_64 postgresql94-server-9.4.6-4.1.x86_64
Using "md5" Method at: host all all 127.0.0.1/32 md5
in "/var/lib/pgsql/data/pg_hba.conf" file.
A role user (named: "ovie") is able to login to DB via pgAdmin3* but failed via psql Command:
$ psql -p 5432 -h localhost -U ovie -W Password for user ovie: psql: FATAL: Ident authentication failed for user "ovie"
Any suggestions?
Thanks in advance.