Postgres database username in database.yml file

Question

How do I find out what is my database's username in my local machine? I'm updating my database.yml file in my rails application, but anything I try isn't working.

When trying to use postgres (or other options such as mymacusername) I'm getting the following error:

FATAL:  role "postgres" does not exist

Do I need to create it? How? Or can I use an existing username on my computer?

Update: I am trying to create a user (this is soon after installation so the issue may be that it doesn't exist yet) I ran createuser -s -U $USER Name of role to add: postgres

But am getting the following error:

createuser: could not connect to database postgres: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/pgsql_socket/.s.PGSQL.5432"?

So this is the problem - How do I make it listen to the correct socket?

Alive Developer · Accepted Answer · 2013-04-24 07:46:16Z

1

if you have root access:

sudo -u postgres psql DATABASENAME

inside it type

\l

to show all databases and its users

answered Apr 24, 2013 at 7:46

Alive Developer

1,0221 gold badge13 silver badges25 bronze badges

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

10 Comments

Lucy Weatherford Over a year ago

I have admin access. I tried that and got sudo: unknown user: postgres

Alive Developer Over a year ago

try to look at here

Lucy Weatherford Over a year ago

Thanks, that seems to be the problem, but the solution isn't there - how can I find that socket and get it to listen to it? I am trying sudo find / -name .s.PGSQL.5432 -ls but not sure how to get postgres to talk to it

Alive Developer Over a year ago

netstat -nlp | grep postgre . The listening port should be the last number. There should be more than 1 entries in the result

Lucy Weatherford Over a year ago

netstat: option requires an argument -- p

|

pavan kalyan · Accepted Answer · 2020-03-27 08:36:49Z

0

We simply need to create postgres role. Commands to create a role name postgres: 1.sudo -u postgres psql 2.CREATE ROLE postgres WITH SUPERUSER CREATEDB CREATEROLE LOGIN ENCRYPTED PASSWORD 'password'

answered Mar 27, 2020 at 8:36

pavan kalyan

111 bronze badge

Collectives™ on Stack Overflow

Postgres database username in database.yml file

2 Answers 2

10 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

10 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related