Обсуждение: BUG #14156: Password Autehentication

Поиск
Список
Период
Сортировка

BUG #14156: Password Autehentication

От
daniudass@hotmail.com
Дата:
VGhlIGZvbGxvd2luZyBidWcgaGFzIGJlZW4gbG9nZ2VkIG9uIHRoZSB3ZWJz
aXRlOgoKQnVnIHJlZmVyZW5jZTogICAgICAxNDE1NgpMb2dnZWQgYnk6ICAg
ICAgICAgIEFkbmFuIEluYXlhdApFbWFpbCBhZGRyZXNzOiAgICAgIGRhbml1
ZGFzc0Bob3RtYWlsLmNvbQpQb3N0Z3JlU1FMIHZlcnNpb246IDkuNC44Ck9w
ZXJhdGluZyBzeXN0ZW06ICAgV2luZG93cyA4LjEKRGVzY3JpcHRpb246ICAg
ICAgICAKCkkgaGF2ZSByZWNlbnRseSBpbnN0YWxsZWQgUG9zdGdyZWVTcWwg
YW5kIHRyeSB0byBydW4gdGhpcyBjb21tYW5kIGluIENvbW1hbmQKTGluZSBJ
bnRlcmZhY2UoY29tbWFuZCBwcm9tcHQpLg0KQnV0IGl0IGlzIGRlbWFuZGlu
ZyB0aGUgcGFzc3dvcmQuIEkgaGF2ZW4ndCBzZXQgYW55IHBhc3N3b3JkLiAN
ClRoZSBwYXNzd29yZCBmb3Igc3VwZXIgYWRtaW4gSSBoYXZlIHNldCwgSSB0
cmllZCB0byBlbnRlciB0aGF0IHBhc3N3b3JkIGJ1dAphdXRoZW50aWNhdGlv
biBmYWlsLiBJIGFtIHN0dWNrLi4uCgo=

Re: BUG #14156: Password Autehentication

От
Michael Paquier
Дата:
On Wed, May 25, 2016 at 1:55 AM,  <daniudass@hotmail.com> wrote:
> I have recently installed PostgreSql and try to run this command in Command
> Line Interface(command prompt).
> But it is demanding the password. I haven't set any password.
> The password for super admin I have set, I tried to enter that password but
> authentication fail. I am stuck...

This is not a bug, but a general question for pgsql-novice or
pgsql-general. If it requests a password for you and you have an
access to the data folder, you could change pg_hba.conf from "md5" to
"trust", then run "pg_ctl reload" or restart the server, and finally
you'll be able to connect without a password.

You may want to check as well if you don't have a PGPASS file, this
depends on how you installed Postgres, and you are providing no
details regarding that, so we are limited to guesses here.
--
Michael