Celestial Database apparently reset

I had finished all test and after try save the project into my repository, it no longer recognized them, like the file didn’t exist, but when I start Postrgre SQL terminal the universe file it still available how I finished it.

How can I solve that? :frowning:

Here I finally save the code:

follow the instructions in how to restore the database from a dump, it’s written in the description

I did it, but it doesn’t work :frowning:

Did you take the dump as mentioned in the instructions? Can you share the steps you are following to restore it?

You should run the below command in the bash terminal(not the PSQL one) to rebuild the DB:

psql -U postgres < universe.sql

I had a similiar issue with the worldcup database where the test runner failed. Deleting the CodeAlly container and starting from scratch helped. How to do this is described here. If you have the dump you can easily recreate the database afterwards.

1 Like

make sure you’re doing it in bash and not psql

Yes, I already had a dump before to see the problem.
I’m trying the description rebuild but is still doesn’t work.

I’ll try @janguenther1 's method

What I did was a dump with the command in the Notes within the project:

  1. pg_dump -cC --inserts -U freecodecamp universe > universe.sql
    
  2. Open the file and copy the content.
  3. Delete the CodeAlly Container (How to do this is in the solution comment).
  4. Start the project and create the universe database to make again a dump and a copy (I did this, I don’t know if works with one file).
  5. Paste in the new copy file the code copied and rebuild with:
    psql -U postgres < universeCopy.sql