Postgres Pro
Downloads
Home   >   mailing lists

Thread: pgadmin4 configuration with no passwords?

pgadmin4 configuration with no passwords?

From
Tom Browder
Date:
I want to start playing with pgadmin4 on my local host (single user) with no passwords for my own databases. Also, I have no password for user postgres since I change to it via su when I need it.

So can I use pgadmin4 for that scenario?  My initial foray into using it in local desktop mode seems to require passwords for everything.

Thanks.

-Tom



Re: pgadmin4 configuration with no passwords?

From
Nagaraj Raj
Date:
Hi Tom,

Yes, you can use password less login through pgAdmin.

In pg_hba.conf file add,

host  all   all  <localhost> trust.


Thanks.
Naga


Sent from Yahoo Mail for iPhone

On Thursday, May 9, 2019, 4:33 PM, Tom Browder <tom.browder@gmail.com> wrote:

I want to start playing with pgadmin4 on my local host (single user) with no passwords for my own databases. Also, I have no password for user postgres since I change to it via su when I need it.

So can I use pgadmin4 for that scenario?  My initial foray into using it in local desktop mode seems to require passwords for everything.

Thanks.

-Tom



Re: pgadmin4 configuration with no passwords?

From
Tom Browder
Date:
On Thu, May 9, 2019 at 22:13 Nagaraj Raj <nagaraj.sf@yahoo.com> wrote:
Hi Tom,
Yes, you can use password less login through pgAdmin.
In pg_hba.conf file add,
host  all   all  <localhost> trust.

Thank you, Naga! I forgot about that conf file after blowing away my old postgresql package and reinstalling pg 11.

Warm regards,

-Tom