In PostgreSQL, how to accept any password for the user "postgres"?

Question

I'm working on many projects simultaneously, and some have some passwords defined as default, which can vary along projects. I've got postgresql installed on my (Ubuntu) laptop and of course I'm only using it locally for devving.

I know it's horribly insecure, but I don't expose postgres remotely. So to make things easier I would like the postgresql server to accept ANY password it is given for the postgres user. Is there any way that I could do this?

Martijn Pieters · Accepted Answer · 2022-10-07 12:32:09Z

2

Set trust for all you local connections in pg_hba.conf like e.g

local   all             all                                     trust

After editing, restart the postgresql service.

edited Oct 7, 2022 at 12:32

Martijn Pieters

1.1m326 gold badges4.2k silver badges3.4k bronze badges

answered Apr 27, 2020 at 9:32

Amjad Shahzad

8427 silver badges15 bronze badges

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

1 Comment

kramer65 Over a year ago

For people wondering where they can find their pg_hba.conf, run psql -U postgres -c 'SHOW config_file' to find it.

Collectives™ on Stack Overflow

In PostgreSQL, how to accept any password for the user "postgres"?

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