Mailinglist Archive: opensuse (527 mails)

< Previous Next >
[opensuse] Succeed Login on pgAdmin3 but Failed via psql Command
  • From: Andi Sugandi <andisugandi@xxxxxxxxx>
  • Date: Thu, 11 Aug 2016 16:16:58 +0700
  • Message-id: <CAP9RdOBmz98Su_1SF5gs5f0fo0Z=dD6ksEnzrWVjZV07u-Xj3Q@mail.gmail.com>
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?

*) http://goo.gl/erhDy6

Thanks in advance.
--
Andi Sugandi.
--
To unsubscribe, e-mail: opensuse+unsubscribe@xxxxxxxxxxxx
To contact the owner, e-mail: opensuse+owner@xxxxxxxxxxxx

< Previous Next >
Follow Ups