Learn Relational Databases by Building a Mario Database

Backend Development
1

Hi ,
I am working on: Learn Relational Databases by Building a Mario Database

Looks like they’re all gone. Remind yourself what columns you have in second_table by looking at its details.

I get following error:
\d second_table;
second_database=> Table “public.second_table”
±---------±----------------------±----------±---------±--------+
| Column | Type | Collation | Nullable | Default |
±---------±----------------------±----------±---------±--------+
| id | integer | | | |
| username | character varying(30) | | | |
±---------±----------------------±----------±---------±--------+

\d second_table;
FATAL: terminating connection due to administrator command
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.
second_database=>

I tried “reset” several times, didn’t work. And server reset did not work.

Any suggestions?

Thanks

2

When you use the login and connect commands do they work successfully?

psql --username=freecodecamp --dbname=postgres
\c <database>
3

That message occurs after you reset - the reset command kicks you off the database so it can be rebuilt. After you see that message, you are connected again - so you should be able to just run the command again.

4

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.