freeCodeCamp / freeCodeCamp/rdb-alpha
Unable to start the lesson where I left off
- Dominant language
- Dockerfile
- Stars
- 173
- Forks
- 1.1k
- PR merge metrics
- No merged PRs in 30d
Description
### Describe the bug
I completed 35% of 'Build a database of Video Game Characters' yesterday. And today when I tried to start the lesson, I am unable to login to psql with the command ```psql --username=freecodecamp --dbname=postgres```.
Here's what I get after I run the command:
`
camper: /project$ psql --username=freecodecamp --dbname=postgres
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"?
`
### To Reproduce
1. Start the lesson for the first time.
2. Quit it.
3. Go to Codespaces page in Github and start it.
### Expected behavior
Should connect to psql normally.
### Screenshots
### Desktop OS
Windows 10
### Desktop Browser
Chrome
### Desktop Browser Version
_No response_
### Mobile Device
_No response_
### Mobile OS
_No response_
### Mobile Browser
_No response_
### Mobile Browser Version
_No response_
### Additional context
_No response_
Contributor guide
Research direction
Start by reproducing the lesson resume flow in GitHub Codespaces: quit the lesson, restart the Codespace, and run `psql --username=freecodecamp --dbname=postgres`. Trace why the local PostgreSQL server is not accepting connections after restart; done means the command connects normally when resuming the lesson.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql
- Domain
- databases, devops
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Quiet
- Clarity
- Mostly clear
- Newbie friendliness
- 55/100