Help with My First Codespace

[mmazurk]

Select Topic Area

Question

Body

I am a student enrolled in a software dev bootcamp, and I'm trying to create a Codespace for one of my class projects that uses Flask-SQLAlchemy and PostgreSQL. I read the documentation, watched videos on how to configure these files in .devcontainer:

• devcontainer.json
• docker-compose.yml
• Dockerfile

... and I did the steps as instructed. The container build seemed to work fine. I wanted to run my app.py file manually in ipython and then look to see if my model.py file worked as intended and built my table as intended. Before I could do that, however, I had to create the database for my app. So tried this at the terminal:

$ `sudo service postgresql start'

And a got a very long error. The crux of the message was: "LOG: could not bind IPv4 address "127.0.0.1": Address already in use 2023-03-23 19:52:35.156 UTC [4977] HINT: Is another postmaster already running on port 5432?"

I couldn't find help online. Can anyone possibly help me? And please be patient because I'm a student. Thank you!

[osortega]

Hello @mmazurk ! 👋
Can you go to the Ports tab in VS Code, next to where the terminal is and verify that there's not another process running on that port?

You could either change the port to a new one or you could make sure that there's no background process running on the port by running lsof -i :5432 and killing the process with kill <pid>.

Hope this helps!

[mmazurk]

Thanks so much for the response @osortega . When I first run the Codespace the only open port I see is 5000. When I try to start postgres with the sudo command, another port suddenly appears on the list ... Port: 35641.

If I had to guess, I'd say that I configured the .devcontainer files incorrectly. There's a few YT videos online I tried to follow, but I think they assume you are already a professional developer. Is there somewhere I can find examples of the .devcontainer files for Flask projects using SQLAlchemy and PosgreSQL?

And again, thank you!

[osortega]

@mmazurk Hmm so I suppose postgres is running on port 35641 so I'm not sure who is using the port 5432.
You can try changing the port where postmaster runs through the configuration.

I'm sorry I'm unfamiliar with the stack you are using and we only have these templates that would help you get started.

[github-actions[bot]]

🕒 Discussion Activity Reminder 🕒

This Discussion has been labeled as dormant by an automated system for having no activity in the last 60 days. Please consider one the following actions:

1️⃣ Close as Out of Date: If the topic is no longer relevant, close the Discussion as out of date at the bottom of the page.

2️⃣ Provide More Information: Share additional details or context — or let the community know if you've found a solution on your own.

3️⃣ Mark a Reply as Answer: If your question has been answered by a reply, mark the most helpful reply as the solution.

Note: This dormant notification will only apply to Discussions with the Question label. To learn more, see our recent announcement.

Thank you for helping bring this Discussion to a resolution! 💬