How to get into postgres using your username?

Question

I am using a postgresql on Ubuntu. It already has my username testuser that I have checked using the following command:

\du

But whenever I create a database, it says that the owner is postgres:

create database tempdb;

I want the user of tempdb to be tempuser rather than postgres. Could you tell me how can I do that?

Vao Tsun · Accepted Answer · 2017-05-01 20:10:17Z

1

try:

CREATE DATABASE tempdb OWNER testuser;

as per docs

answered May 1, 2017 at 20:10

Vao Tsun

52.4k13 gold badges114 silver badges149 bronze badges

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

Comments

Brian · Accepted Answer · 2017-05-01 20:08:36Z

0

Are you using psql? If so, the --username flag will allow you to connect as testuser.

answered May 1, 2017 at 20:08

Brian

5,5112 gold badges28 silver badges32 bronze badges

I have logged in using the following command: sudo -u postgres psql

Sounds like you already solved your issue, but sudo -u postgres psql --username testuser might also help.