Issues with PostgreSQL 9.6

[frapik99]

Hi,
I have installed PostgreSQL but i try nodal db:create I have the following error: Database Error: password authentication failed for user "postgres" I tried to reset the password but nothing. I cannot even create the user using createuser postgres -s as suggested because postgres was already created. Any idea on how to solve it?

EDIT: I renamed postgres to postgresold using ALTER ROLE postgres RENAME TO postgresold;, after that i create the user using createuser postgres -s but I still have the same error.

Thanks

[nogsantos]

Hello,
I think this is not a nodal issue, maybe, your db.json file, in config folder on your project is not set properly, or your postgreSQL user has no permission, or connections are not allowed from your host... Did you try to review your postgres configurations pg_config, postgres.conf?