Postgres asking for System Users password

Question

I have set up Postgres and want to use

pg_dump -Fc mydb > dump.db

to copy the content of my db into a file. pg_dump is asking e for the System Users password, which does not work. I have never asked Postgres to use my system user as the default user. I'd be incredibly happy with the default user:postgres password:postgres, but Postgresql is making things hard for me. Any help is greatly appreciated. I do not need the system user in my pg database

then add the user name you want to use to the command: pg_dump -U postgres ... — JGH
– JGH, Commented Mar 29, 2021 at 13:53
@JGH Thanks! The flag actually works. but im running into this issue many times and would like to solve it without having to manually specify the user each time — Tobi
– Tobi, Commented Mar 29, 2021 at 14:29

jjanes · Accepted Answer · 2021-03-29 14:22:37Z

2

You can customize the "defaults" by setting environment variables. PGUSER, PGPASSWORD. Be aware though that it may be possible for other users of the system to see your PGPASSWORD setting, so for that a .pgpass file would generally be preferred.

answered Mar 29, 2021 at 14:22

jjanes

45k5 gold badges39 silver badges48 bronze badges

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

1 Comment

Tobi Over a year ago

can i get rid of the default system user by using .pgpass?

Collectives™ on Stack Overflow

Postgres asking for System Users password

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related