Re: [ADMIN] New to postgreSQL

On Mon, Sep 4, 2017 at 7:41 PM, Ramesh <ramesh4f@gmail.com> wrote:
> HI all
>
> Im new to postgres.
>
> I tried to create user with the command createuser from outside the psql
> client.  But got the below error.
>
> Based on tutorial, I could see the createuser <<username>> gets created, but
> while login it will throw error.  My case is like below.
>
>
> [postgres@localhost ~]$ createuser mytest
> Password:
> createuser: could not connect to database postgres: FATAL:  password
> authentication failed for user "postgres"

This could be due to enabling md5 authentication for user postgres.
And password not yet set up for the user postgres.

Check pg_hba.conf.



--
Regards,

Tirveni Yadav
www.udyansh.org
www.bael.io

What is this Universe ? From what it arises ? Into what does it go?
In freedom it arises, In freedom it rests and into freedom it melts away.
Upanishads.