Regarding psql "sudo su" to create the password seems to work to create the database. However, it still asks for the password for the user "ozan" although the setting is "trust" for "all" in the file "pg_hba.conf" file. However, I am not getting what is happening in the background. I am still wondering why this is not running as it is supposed...
Try Postico. It’s a Mac client. The two (terminal) and that app will flush out your needs.
Second, su into the Postgres user to create users. Sounds like your users are bungled. Only the Postgres user can do stuff until you create another user with proper privs.
> On Oct 23, 2018, at 6:26 PM, Ozan Kahramanogullari <ozan.kah@gmail.com> wrote: > > Thank you, Andrej. I tried the instructions in this website. However, this did not provide the desired outcome. I am pasting the command line below.Also, the command "psql -h localhost" did not work. > > XXX:src3 ozan$ psql -h localhost > Password: > psql: FATAL: password authentication failed for user "ozan" > > XXX:src3 ozan$ psql -U postgres > psql (10.5) > Type "help" for help. > > postgres=# CREATE USER ozan WITH PASSWORD 'parrot'; > CREATE ROLE > postgres=# \q > > XXX:src3 ozan$ psql > Password: > psql: FATAL: database "ozan" does not exist > > XXX:src3 ozan$ psql -U postgres > psql (10.5) > Type "help" for help. > > postgres=# GRANT ALL PRIVILEGES ON DATABASE lecture to ozan; > GRANT > > postgres=# \q > > Ozan's MacBookPro:src3 ozan$ psql > Password: > psql: FATAL: database "ozan" does not exist >
