How to map user to database in postgresql, change password[WINDOWS]

Asked Sep 06 '17 at 08:13

Active Sep 07 '17 at 15:57

Viewed 297 times

I have following spring boot configuration:

spring.datasource.url=jdbc:postgresql://localhost:5432/study-designer-dev
spring.datasource.username=postgres
spring.datasource.password=sa

But when I start my application I see:

Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "postgres"

But I am sure that I typed sa password for default(I thinks it is postgres) user

I don't see menu where I can change password, map user to database and so on.

Please clarify how can I do this ?

P.S.

I have seen this link but I have not idea how to ask pgadmin show this dialog

edited Sep 07 '17 at 15:57

Murtuza Z

asked Sep 06 '17 at 08:13

gstackoverflow

have a look at https://www.postgresql.org/docs/9.1/static/auth-pg-hba-conf.html **especially example 19.1** – Scary Wombat Sep 06 '17 at 08:17
try a look here: https://stackoverflow.com/questions/10845998/i-forgot-the-password-i-entered-during-postgres-installation – Matthias Hamann Sep 06 '17 at 08:18
Where can I type commands like**psql -h 127.0.0.1 -U postgres** – gstackoverflow Sep 06 '17 at 08:21
if windows then open a command/dos prompt – Scary Wombat Sep 06 '17 at 08:22
`alter user ... with password ...` https://www.postgresql.org/docs/current/static/sql-alteruser.html – Sep 06 '17 at 08:23
@Scary Wombat can you clarify folder path? – gstackoverflow Sep 06 '17 at 08:26
Are you really asking me how to find a file on windows? Also I think yiou can open this file from pgadmin – Scary Wombat Sep 06 '17 at 08:31

0 Answers0