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é, Nov 05 '13 at 16:53

score 1 · Accepted Answer · answered Nov 06 '13 at 07:14

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 06 '13 at 07:14

Kalev Kalm

39
7

score 0 · Answer 2 · edited May 23 '17 at 10:32

0

Check this out: Postgres password

or this: Stackoverflow Postgres Password

edited May 23 '17 at 10:32

Community

1
1

answered Nov 05 '13 at 10:44

LotusUNSW

2,027
18
20

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 – Kalev Kalm Nov 05 '13 at 11:05
Here's a final link which might help: http://dba.stackexchange.com/questions/36137/postgresql-user-can-not-connect-to-server-after-changing-password – LotusUNSW Nov 05 '13 at 11:14

postgres : Password login error

2 Answers2