Mailinglist Archive: opensuse (527 mails)

< Previous Next >
Re: [opensuse] Succeed Login on pgAdmin3 but Failed via psql Command
  • From: Ico Petrov <ico@xxxxxxxxxxxxxxxx>
  • Date: Fri, 12 Aug 2016 09:11:25 +0300
  • Message-id: <1749085.fIj2m97Ic3@es1>
Hi,

No, I mean this one:

local all all md5

Regards.
------------------------------------------------------------------------------
On Friday, 12 August, 2016 13:00:59 Andi Sugandi wrote:
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,
--
To unsubscribe, e-mail: opensuse+unsubscribe@xxxxxxxxxxxx
To contact the owner, e-mail: opensuse+owner@xxxxxxxxxxxx

< Previous Next >