Ask A Question

Notifications

You’re not receiving notifications from this thread.

SQL Learning Path - Creating and Dropping Databases Discussion

Initially, I got a connection error, to the effect, 'database 'my_user_name' does not exist.

After running createdb and then psql, everything works and I was able to connect using 'TablePlus' : )

Reply

Type "psql -l" to your command to check existing databases (without quotes "")

Reply

This a good one that I run every so often to check for any old databases laying around that I can get rid of, so good call on mentioning it!

Reply

Hi mate, should probably mention somewhere to createdb. I spent a good 20 minutes trying to figure out why tablePlus couldn't connect with the new database.

Reply
Join the discussion
Create an account Log in

Want to stay up-to-date with Ruby on Rails?

Join 77,200+ developers who get early access to new tutorials, screencasts, articles, and more.

    We care about the protection of your data. Read our Privacy Policy.

    Screencast tutorials to help you learn Ruby on Rails, Javascript, Hotwire, Turbo, Stimulus.js, PostgreSQL, MySQL, Ubuntu, and more.

    © 2023 GoRails, LLC. All rights reserved.