Celestial Bodies Database - Cannot create universe database

Backend Development
1

Tell us what’s happening:
I’m trying to create database universe but for some reason it couldn’t be created. When I tried to connect, it showed “connection to server on socket “/var/run/postgresql/.s.PGSQL.5432” failed: FATAL: database “universe” does not exist
Previous connection kept”

My code is shown below:

FCC
FCC1136×469 61.3 KB

Your browser information:

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

Challenge: Celestial Bodies Database - Build a Celestial Bodies Database

Link to the challenge:

2

try the create statement again but this time add a semicolon at the end of it. (i believe all these statements needs semicolon ; at the end)

3

Thanks a lot. It works. I don’t recall I put semicolon when create database in previous sessions but it works beautifully with semicolon.

1 Like