Enforcing Password Authentication in PostgreSQL (Development Environment)

Hi everyone,

I’m working in a development environment with PostgreSQL and I have a question regarding authentication. I know that the current configuration we have in idx for PostgreSQL is intended for a development environment, where authentication is usually more relaxed.

However, I would like to know if it’s possible to configure PostgreSQL to require users to enter a password every time they try to connect , even in this development context. My intention is to have stricter access control, even if it’s only in the development environment.

I understand that this might not be the standard configuration for idx, but I would like to explore the options and learn the best way to do it. Does anyone have experience configuring PostgreSQL for this type of more robust authentication, even locally?