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.