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: hub.docker.com/_/postgres — Eric Wilson
– Eric Wilson, Commented Apr 4, 2017 at 12:15

adm-gis · Accepted Answer · 2024-05-14 11:58:31Z

58

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 https://www.postgresql.org/docs/current/sql-createrole.html for information on the CREATE ROLE options.

edited May 14, 2024 at 11:58

adm-gis

1562 silver badges13 bronze badges

answered Mar 4, 2011 at 2:39

digitaljoel

26.6k15 gold badges94 silver badges116 bronze badges

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

2 Comments

Theodore R. Smith Over a year ago

+1 Thank you very much. I looked everywhere but this is the only clear , concise, and working answer I've found ;-)

Cody Over a year ago

Is there any difference between login role and ordinary user like postgres ?

Rayz · Accepted Answer · 2017-04-04 10:29:45Z

5

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 4, 2017 at 10:29

Rayz

5331 gold badge5 silver badges19 bronze badges

Comments

Greg Hewgill · Accepted Answer · 2011-03-04 02:39:45Z

2

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).

answered Mar 4, 2011 at 2:39

Greg Hewgill

1.0m192 gold badges1.2k silver badges1.3k bronze badges

Comments

barbsan · Accepted Answer · 2019-06-03 13:19:31Z

1

This worked for me --username Shweta;

Now to create a database create database db;

edited Jun 3, 2019 at 13:19

barbsan

3,46811 gold badges23 silver badges29 bronze badges

answered Jun 3, 2019 at 13:11

valkyrie55

5056 silver badges10 bronze badges

Comments

James Risner · Accepted Answer · 2022-11-09 01:57:19Z

1

The simplest case is to use the Windows command line and as I understand that the user posgres is present:

psql -U postgres -c "CREATE ROLE shpp;"

psql -U postgres -c "ALTER ROLE  shpp WITH LOGIN;"

psql -U postgres -c "ALTER USER  shpp CREATEDB;"

psql -U postgres -c "ALTER USER  shpp WITH PASSWORD 'shpp';"

In my shpp example, this is the name and password of the new user.

edited Nov 9, 2022 at 1:57

James Risner

6,09711 gold badges33 silver badges60 bronze badges

answered Nov 5, 2022 at 11:50

Sekator

112 bronze badges

Collectives™ on Stack Overflow

How to add a user to PostgreSQL in Windows?

5 Answers 5

2 Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

2 Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related