On Mon, Sep 4, 2017 at 7:41 PM, Ramesh <ramesh4f@xxxxxxxxx> 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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
