error: password authentication failed for user "notesadmin"

[dugiwarc]

I cloned the repo, and ran npm install
When I access localhost:4000 I get the following error:
error: password authentication failed for user "notesadmin"

[poteto]

Did you setup the database? Could you share the whole error?

[tiberiu80]

I had the same error but then i setup db and worked.
I had a problem setting up postgresql db but i fixed it and managed to start the app.
My setup went like this:
Step 1. Create the Database
psql postgres

CREATE DATABASE notesapi;
CREATE ROLE notesadmin WITH LOGIN PASSWORD 'password';
ALTER ROLE notesadmin WITH SUPERUSER;
ALTER DATABASE notesapi OWNER TO notesadmin;
\q
All fine.
Step 2
psql -d postgres -U notesadmin; <--- here i got ' psql: FATAL: Peer authentication failed for user "notesadmin" ' in terminal.
After some quick research i found https://stackoverflow.com/questions/18664074/getting-error-peer-authentication-failed-for-user-postgres-when-trying-to-ge which explains why you can't connect with 'notesadmin' user.
I didn't want to change postgresconfig so i did some more research and found https://stackoverflow.com/questions/17443379/psql-fatal-peer-authentication-failed-for-user-dev/17443990 which led me to use
psql -U notesadmin -h 127.0.0.1 -d notesapi which worked
From here i did the following steps and app started
\c notesapi

DROP TABLE IF EXISTS notes;
CREATE TABLE notes (
id SERIAL PRIMARY KEY,
created_at TIMESTAMP NOT NULL,
updated_at TIMESTAMP NOT NULL,
title TEXT,
body TEXT
);

\q

Step 3. Run the seed script
Finally, run npm run seed to populate some data.
npm start
Hope this save someone's time.