Problem setting up bitbucket with PGSQL

[sharad mishra]

I have been trying to setup my bitbucket server with postgresql but i am getting the following error. I have tried with different passwords but i am not able to get past this step. Pl help.

The configuration entered is not valid. A database connection could not be established. Please check your configuration and try again.
	com.atlassian.stash.internal.db.DefaultDatabaseManager.validateConfiguration(DefaultDatabaseManager.java:217)
	com.atlassian.stash.internal.db.DefaultDatabaseManager.prepareDatabase(DefaultDatabaseManager.java:183)
	com.atlassian.stash.internal.maintenance.SpringMaintenanceTaskFactory.setupTask(SpringMaintenanceTaskFactory.java:151)
	...
Failed to obtain JDBC Connection; nested exception is org.postgresql.util.PSQLException: FATAL: password authentication failed for user "*******"
	org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:81)
	com.atlassian.stash.internal.db.DefaultDatabaseValidator.validate(DefaultDatabaseValidator.java:44)
	com.atlassian.stash.internal.db.DefaultDatabaseManager.validateConfiguration(DefaultDatabaseManager.java:214)
	...
FATAL: password authentication failed for user "*******"
	org.postgresql.Driver$ConnectThread.getResult(Driver.java:405)
	org.postgresql.Driver.connect(Driver.java:263)
	java.sql.DriverManager.getConnection(DriverManager.java:664)

[Yogesh Mude]

HI @sharad mishra 

Welcome to the community!

Please try to reset the database password and then try it once again.

ALTER USER <DB_NAME> WITH PASSWORD '<PWD>';

[sharad mishra]

Hi Yogesh. Should it not be <USER_NAME>; Anyway, I tried this but it didn't help.

[Yogesh Mude]

Sorry, it's not a Database name but its a role name using which you are accessing the database.