dwyl / learn-postgresql

🐘 Learn how to use PostgreSQL and Structured Query Language (SQL) to store and query your relational data. 🔍
212 stars 23 forks source link

Default users and roles #36

Closed tbtommyb closed 7 years ago

tbtommyb commented 7 years ago

On OS X, clicking 'open psql' connects to psql using the role for the user account, which Postgres.app creates automatically on installation and uses by default. I think the instructions on creating the role aren't needed.

On Ubuntu this user isn't created automatically, hence the need to log in as 'postgres' and then create a user. I think it would be easier if the Ubuntu instructions had an extra step to create a role and database for the user account.

The benefit of this is that people don't need to worry about switching users to connect and it makes the instructions easier to understand without having to go too far into the whole users vs roles thing.

I am going to fork this and make the changes ahead of the Week 6 installation party, shall I also make a PR to here so you can review and see what you think?