postgres : Password login error

Question

I have installed postgreSQL and I have made a password for Postgres 'admin'. I can log in with the postgres and password as long as its in the local host, as soon as I change the host form localhost to an IP it doesn't accept the password, we have another user that I can use but since its not a superuser I cant modify or make procedures is pgAdmin.

So the question is: Can I somehow reset the password for the postgres, I have tried to modify pg_hpa.config

host    all             all             127.0.0.1/32           trust
# IPv6 local connections:
host    all             all             ::1/128                trust

but that did me no good, so any suggestions of how to reset, or add a password (I also tried this on: ALTER USER postgres VALID UNTIL 'infinity';) or change is would be appreciated.

What's the error message when trying to connect non-locally? — Daniel Vérité
– Daniel Vérité, Commented Nov 5, 2013 at 16:53

Kalev Kalm · Accepted Answer · 2013-11-06 07:14:06Z

1

I actually have this problem resolved, I couldn't get in there because I only had the local password but fortunately our database manager got the postgres password for the IP that we use. Sorry to have taken up your time guys and thanks.

answered Nov 6, 2013 at 7:14

Kalev Kalm

397 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 10:32:14Z

0

Check this out: Postgres password

or this: Stackoverflow Postgres Password

edited May 23, 2017 at 10:32

CommunityBot

11 silver badge

answered Nov 5, 2013 at 10:44

LotusUNSW

2,02719 silver badges20 bronze badges

2 Comments

Kalev Kalm Over a year ago

Well I might have done something wrong, anyway it still asks the password from me, and I couldnt see the other tips because they were confidential

LotusUNSW Over a year ago

Here's a final link which might help: dba.stackexchange.com/questions/36137/…

Collectives™ on Stack Overflow

postgres : Password login error

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related