Mailinglist Archive: opensuse (527 mails)

< Previous Next >
Re: [opensuse] Succeed Login on pgAdmin3 but Failed via psql Command
  • From: Ico Petrov <ico@xxxxxxxxxxxxxxxx>
  • Date: Thu, 11 Aug 2016 20:49:02 +0300
  • Message-id: <4966680.y8A9ZobbIT@es1>
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?

*) http://goo.gl/erhDy6

Thanks in advance.
< Previous Next >
Follow Ups
References