Celestial Bodies Database - Build a Celestial Bodies Database

Backend Development
1

Tell us what’s happening:
Completed all the steps. The universe.sql file disappeared, I accidently deleted it while trying to “public repository and submit the URL to it below”. I am trying to rebuild the database. I am getting this error:
codeally@f2cecf4a0168:~/project/learn-celestial-bodies-database$ psql --username=freecodecamp --dbname=postgres
psql: error: connection to server on socket “/var/run/postgresql/.s.PGSQL.5432” failed: No such file or directory
Is the server running locally and accepting connections on that socket?

Your code so far
Got deleted accidently

Your browser information:

User Agent is: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/109.0.0.0 Safari/537.36

Challenge: Celestial Bodies Database - Build a Celestial Bodies Database

Link to the challenge:

2

Try running these two commands in the terminal @IBarisa:

  • sudo chown -R postgres:postgres /var/lib/postgresql/12/main
  • sudo service postgresql restart

Let us know if that works.

3

This did not work. I am still receiving the same error.

4

You could try hitting the reset button. It should run the commands to set the database back up. I’m quite sure that won’t affect any data that exists in your database, but I believe your database doesn’t get saved if the container has shut itself down - so your data may not be there.