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: <>

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 md5

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

The result is still (of course after running systemcl restart

$ 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