Build a Database of Video Game Characters - Build a Database of Video Game Characters

Backend Development
1

Tell us what’s happening:

I’ve completed the lesson “Learn Bash by Creating a Boilerplate.” Now I’d like to start “Build a Database of Video Game Characters.” I tried the local method via docker but it goes back to the bash course. I want to get to the new project. How can I reset it so I do the project?

Your code so far

Your browser information:

User Agent is: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36

Challenge Information:

Build a Database of Video Game Characters - Build a Database of Video Game Characters

2

try the workaround posted here

1 Like
3

The instructions helped me to get back on track. I closed the window and tried to resume it, but I wasn’t able to reconnect to the Postgres database using this command:psql --username=freecodecamp --dbname=postgres

I got the following error when trying to reconnect to the server:
psql: error: could not connect to server: Connection refused
Is the server running locally and accepting
connections on Unix domain socket “/var/run/postgresql/.s.PGSQL.5432”?

4

can you show me a screenshot? I need to see if your environment got corrupted.

You can also try to close the terminal you’re currently in, then click Reset
then open a new terminal and try again.

5

Screenshot_20251129_090242
Screenshot_20251129_0902421912×1024 66.5 KB

To resume the course on my local docker instance, I executed this command on the rdb-alpha repo: code --user-data-dir ./vscode-profile --extensions-dir ./vscode-extensions . After that I pressed ctrl + shift + p for the commands menu and clicked on reopen in container. I launched the CodeRoad extension but I couldn’t connect to the psql server using this command: psql --username=freecodecamp --dbname=postgres

I got the following error when connecting to the server:
psql: error: could not connect to server: Connection refused
Is the server running locally and accepting
connections on Unix domain socket “/var/run/postgresql/.s.PGSQL.5432”?

As far as I’m aware, I shouldn’t have issues on my end. Could it be an issue related to how it saves progress between the normal way as freecodecamp instructed and what you suggested with code --user-data-dir ./vscode-profile --extensions-dir ./vscode-extensions .

6

if closing the terminal, then running Reset, then opening a new terminal didn’t help (your last message didn’t say if you tried this or not), then we’ll have to do some trial and error to see if we can help you out.

Starting with:
sudo systemctl start postgresql.service && systemctl status postgresql.service

Try this command to start the service (in case it is no longer running).

If postgresql is active, you can then press Q to quit the status screen.

7

I tried a different solution. The first thing I did was starting over from scratch with the following steps on my local environment with docker:

  1. git clone ``https://github.com/freeCodeCamp/rdb-alpha
  2. cd rdb-alpha and code --user-data-dir ./vscode-profile --extensions-dir ./vscode-extensions .
  3. It prompted me to install the dev-containers extension again
  4. I ran dev-container: rebuild container without cache
  5. Afterwards I ran CodeRoad: Start

I got the assignment working on my end, but unfortunately I had to start over again. Currently when I exit and resume the assignment, I would reopen the container when the prompt pops up on the bottom right, open coderoad, then close the terminal and reset it like you suggested.

If there’s any further issues on this assignment, I will reply to this forum.