Connecting to postgres as ubuntu standard user

Question

I want to connect to my postgresql when running my python program. The issue i face is that my username is dave, but i can only access my database with the user postgres on linux. This constellation never failed me on my mac, because i could start postgres from my "dave" user account. With linux (ubuntu) i can only connect to the database with psql, when switching my user with *sudo -su postgres to the postgres user.

How am i able to start my program from my user dave while accessing the database?

https://stackoverflow.com/questions/15301826/psql-fatal-role-postgres-does-not-exist — David, Jun 09 '20 at 00:42

score 1 · Accepted Answer · answered Jun 09 '20 at 01:18

You'll have to create a user called dave:

Log on using sudo -u postgres
create database davedb;
create user dave with encrypted password 'testing';
grant all privileges on database davedb to dave;

Then, you can log in from your username itself like so:

psql dave davedb
--or--
psql -U dave -d davedb

If it asks you for your password, type it. You should be in then.

Connecting to postgres as ubuntu standard user

1 Answers1