search

keithwhor / nodal

API Services Made Easy With Node.js
http://www.nodaljs.com/
MIT License
4.51k stars 209 forks source link

Issues with PostgreSQL 9.6 #317

Open frapik99 opened 7 years ago

frapik99 commented 7 years ago

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 commented 7 years ago

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?