Mailinglist Archive: opensuse (527 mails)

< Previous Next >
Re: [opensuse] Succeed Login on pgAdmin3 but Failed via psql Command
  • From: Andi Sugandi <andisugandi@xxxxxxxxx>
  • Date: Fri, 12 Aug 2016 13:00:59 +0700
  • Message-id: <CAP9RdOBurGvOgZiMA3yYP=nDL17i2P6aegHJPK_EBV0kOC_-jQ@mail.gmail.com>
Hi,

On Fri, Aug 12, 2016 at 12:49 AM, Ico Petrov <ico@xxxxxxxxxxxxxxxx> wrote:

What is the authentication method for the local connections type ? Ident ?
Change it to md5, restart postgres and try again.

Did you mean this one?

Using "md5" Method at:
host all all 127.0.0.1/32 md5

in "/var/lib/pgsql/data/pg_hba.conf" file.

The result is still (of course after running systemcl restart
postgresql.service):

$ psql -p 5432 -h localhost -U ovie -W
Password for user ovie:
psql: FATAL: Ident authentication failed for user "ovie"


Best regards,
--
Andi Sugandi.
--
To unsubscribe, e-mail: opensuse+unsubscribe@xxxxxxxxxxxx
To contact the owner, e-mail: opensuse+owner@xxxxxxxxxxxx

< Previous Next >
Follow Ups