createuser command for postgres failing on windows

Question

I installed postgresql on Windows. When I run createuser in the DOS prompt, it fails with the following error:

createuser testuser

could not connect to database postgres : FTAL: role testuser does not exist

I have tried switching the pg_hba file from md5 to trust, but that has not solved the issue. Any thoughts? The database server itself is running- I was able to connect to it using another tool. Also, the path has a reference to the postgres/bin directory.

please post as answer and I will accept. How do I setup the pwd for the new user? — user3813256
– user3813256, Commented Sep 23, 2015 at 23:23

Doon · Accepted Answer · 2015-09-23 23:25:54Z

2

you need to specify a super user account in order to create a user

createuser -U pgsql testuser

if you plan on using a password for this user you can use -P or --pwprompt

createuser -P  -U pgsql testuser

and it will prompt you for the password.

replace pgsql with a superuser account.

answered Sep 23, 2015 at 23:25

Doon

20.3k3 gold badges42 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

createuser command for postgres failing on windows

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related