I feel like the newbie corner is my home on these forums, there's so much to learn
I just ran
which psql and I got:
As far as I know
/usr/bin/ is where all installed programs usually sit, so I thought to myself, cool, I should be able to just run
psql, but I was wrong. I got:
➜ ~ psql psql: error: could not connect to server: FATAL: role "jwan" does not exist
I know the server is running, because I ran
sudo systemctl status postgresql and it tells me it is Active (running).
I suspect when I run
psql certain assumptions are being made on my behalf and I've no idea what those are. Can you please tell me?
The narrative I had in mind was:
- connect to postgres
- run a command to see what databases I have
- pick a database and connect to it, or create a new database
Is the above narrative "valid"?