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
>
>