Build a Celestial Bodies Database - Build a Celestial Bodies Database

Backend Development
1

Tell us what’s happening:

I had to stop working on my project overnight and I thought I followed the instructions properly to dump the file but now I can’t seem to retrieve my data with psql -U postgres < universe.sql. I keep getting the following error:
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”?
How can I recover it? I really don’t want to have to start over!

Your code so far

camper: /project$ psql -U postgres < universe.sql
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”?
camper: /project$

Your browser information:

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

Challenge Information:

Build a Celestial Bodies Database - Build a Celestial Bodies Database

2

it sounds like the server is off (so the issue is not in your file)

Can you try to close out the terminal and then try to click the Reset button?
After that open a new terminal and see if the psql command will work?

3

Thank you, this seems to have worked!

1 Like