Re: psql on Mac

Thanks, Bee!

I am happy to try Postico eventually.

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

Cheers,
Ozan



On Wed, 24 Oct 2018 at 01:25, Bee.Lists <[email protected]> wrote:

> 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 <[email protected]>
> 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
> >
>
>
>
> Cheers, Bee
>
>
>
>
>