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