How to add a user to PostgreSQL in Windows?

Question

I'm running PostgreSQL on mt Windows 7 machine. To run a database I type:

C:\psql -Upostgres mydb

and this works, but it would be nice if I could leave off the -U stuff, but then Postgres thinks I'm trying to log in as 'Eric', since that is my user profile.

So I need to add a user to Postgres, obviously. But how? If I try:

C:\createuser Eric

Postgres thinks I'm trying to add a user Eric as the user Eric which fails. Adding the -U flag doesn't seem to work here.

What am I missing? My command window is in administrator mode, and there is no sudo available, obviously.

Looking back six years later, I would probably not attempt this. Installing Postgres on dev machines is a pain, just use the standard Postgres/Docker image: https://hub.docker.com/_/postgres/ — Eric Wilson, Apr 04 '17 at 12:15

digitaljoel · Accepted Answer · 2011-03-04T02:55:08.580

53

In pgadmin you can create a new "Login Role" and name it Eric and give it permissions graphically, or from command line you can do something like this

psql -U postgres -c "CREATE ROLE Eric LOGIN NOSUPERUSER INHERIT CREATEDB CREATEROLE;" mydb

see http://developer.postgresql.org/pgdocs/postgres/sql-createrole.html for information on the CREATE ROLE options.

edited Mar 04 '11 at 02:55

answered Mar 04 '11 at 02:39

digitaljoel

25,818
15
86
115

2

+1 Thank you very much. I looked everywhere but this is the only clear , concise, and working answer I've found ;-) – Theodore R. Smith Sep 03 '12 at 00:38
Is there any difference between login role and ordinary user like postgres ? – Cody Mar 26 '17 at 07:46

score 4 · Answer 2 · answered Apr 04 '17 at 10:29

4

Just to add more information. From official documentation: you can specify the user under which createuser utility logs in to postgres via environment variable:

PGUSER

One liner for powershell:

& { $env:PGUSER="postgres"; .\createuser.exe Eric}

answered Apr 04 '17 at 10:29

Rayz

523
1
4
19

score 2 · Answer 3 · answered Mar 04 '11 at 02:39

The documentation for createuser indicates that a -U switch is accepted:

-U username
--username username

User name to connect as (not the user name to create).

This is what I would expect to use (although I've never tried to set up PostgreSQL on Windows, only on unices).

score 0 · Answer 4 · edited Jun 03 '19 at 13:19

0

This worked for me --username Shweta;

Now to create a database create database db;

edited Jun 03 '19 at 13:19

barbsan

3,328
11
20
28

answered Jun 03 '19 at 13:11

valkyrie55

277
2
10

How to add a user to PostgreSQL in Windows?

4 Answers4

Linked