I have a linux user account, postgresql role, and associated database, all called foo.
from the linux user foo, I ran the command
Now when I try to run psql from the linux user foo, I get the error...
psql: FATAL: database "foo" does not exist
So does this mean that when running psql from a linux user account, there must be a database associated with that linux user account?