Celestial Bodies Database - Build a Celestial Bodies Database

Backend Development
1

Tell us what’s happening:

To finish the project, Build a Celestial Bodies Database
it tells me that I must start it, I already finished it from VS Code

image
image989×440 33 KB

locally, I cannot make the code from the browser because code Ally does not work from the browser when I authorize code Ally with my GitHub it returns me

this is the link of the universe.sql

and also I’m blocked in the forum

could you help me please and regarding boilerplate and Mario database, I already finished those projects locally but my freeCodeCamp account does not reflect my progress on it;

Regards

Your code so far

Your browser information:

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

Challenge Information:

Celestial Bodies Database - Build a Celestial Bodies Database

2

You’ll find these instructions at the start of some of these lessons but here they are again.

If the task was to create a database (for example, Celestial Bodies Database) and you’ve already done this work on some machine, you can dump the database, essentially creating an sql file that contains all the instructions (queries) to recreate that database.

  1. Run the following in a terminal (not inside the psql shell) on your local machine (where you did all this work):
pg_dump -cC --inserts -U freecodecamp universe > universe.sql
  1. Then start the online version of the task.
  2. Create an empty universe.sql in the VSCode running in the browser.
  3. Copy/paste from local universe.sql into remote.
  4. Run the following in a terminal window in the VSCode running in the browser:
psql -U postgres < universe.sql

You have now recreated the local database in the remote environment. Run the tests and you should be good to go (freecodecamp should pick up on this).

codeally was down and I was having trouble as well, but it’s fine now.