Learn Relational Databases by Building a Database of Video Game Characters - Build a Database of Video Game Characters

Tell us what’s happening:

It’s stressful to code repeatedly.
I’m facing connect to database after gitpod timeout->

psql: error: connection to server at "127.0.0.1", port 5432 failed: Connection refused
        Is the server running on that host and accepting TCP/IP connections?

Your code so far

Your browser information:

User Agent is: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:140.0) Gecko/20100101 Firefox/140.0

Challenge Information:

Learn Relational Databases by Building a Database of Video Game Characters - Build a Database of Video Game Characters


also when I change the database name from postgres to mario_database still not working

psql: error: connection to server at "127.0.0.1", port 5432 failed: FATAL:  role "freecodecamp" does not exist```


Any one who solved this issue, please give me the code.  to connect with postgreSQL.

Does your starting screen look like this?

camper: /project$ echo hello PostgreSQL
hello PostgreSQL
camper: /project$ psql --username=freecodecamp --dbname=postgres
1 Like

yes.
Always timeout I’m in a loop happened more than 6 times , i was close enough to complete 70% , 50%, 60%. I don’t know what do i do. Help me.

I’m doing it again and again, I’m not disappointed or loose motivation it’s good it’s like i am practicing again and again but still I want to finished it. In order to move forward.

Help brother!

Your original post indicated you could not connect to the database. That’s why I posted the database connection string. Are you connected now? Can you show your screen? I really haven’t had a gitpod timeout…other issues, yes, but not that.

You can see the process when I’m submitting the echo code
In which level I was

So, you’re starting all over again. And now you need to enter the connection string, right? I’ve never seen that “History restored” message in the terminal before, and I thought I’d hit all of the gitpod glitches. :slight_smile:

True. There no other way to start from where I left. So, I’m thinking I have to start all over again! That’s little bit disappointment. How much I work done so many times. I think there should be a way but still I have to work from start. It was great to have conversation to my fellow colleague. Thank you!

I’m gonna do it again.
Have a good day.

You should be able to go to your Gitpod dashboard and open your entry there to continue where you left off. If you have more than one entry for the same project though, you may need to delete all but one.

I responded to this post to document what worked for me. Hopefully, you’ll find something helpful there:

CodeRoad help in relational db course - Backend Development - The freeCodeCamp Forum