Re: psql on Mac

Have you tried being explicit about both the database name and the user
name?

psql --dbname=lecture --username=ozan

or

psql -d lecture -U ozan


On 10/23/2018 06:26 PM, Ozan Kahramanogullari 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
> 
>