From: | Dave Page <dpage(at)pgadmin(dot)org> |
---|---|
To: | Andrew Coleman <penguincoder(at)gmail(dot)com> |
Cc: | pgadmin-hackers <pgadmin-hackers(at)lists(dot)postgresql(dot)org>, Syed Fahar Abbas <fahar(dot)abbas(at)enterprisedb(dot)com> |
Subject: | Re: passwords enabled by default |
Date: | 2019-06-27 15:15:52 |
Message-ID: | CA+OCxoy28r9zWG5u1jagf-6B4274H0A5P4iU_rJ4jr6n7t-O8A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
Fahar, can you verify that the Password File option works as expected (or
not) in a non-containerised environment? It should *not* require PGPASSFILE
to be set (because that's basically what it should be doing for us).
Thanks.
On Thu, Jun 27, 2019 at 8:27 AM Andrew Coleman <penguincoder(at)gmail(dot)com>
wrote:
> Recently, while testing my changes to entrypoint.sh in Docker, I noticed
> that you cannot import or export passwords via the servers.json file. You
> can get around this by setting the PassFile option in servers.json, but
> that still doesn't work correctly. For me to make this work, I had to also
> set the `PGPASSFILE` to the full path location of the pgpass file generated
> for me by Helm.
>
> To clarify, I know how many servers I want to connect to and how to find
> their passwords in Kubernetes via their secret, and I use Helm to stitch
> all of that together into a pgpass file that psql and pgadmin4 can use to
> connect to the servers without user intervention.
>
> The presence of the pgpass file and the reference to that file in the
> servers.json was not enough to allow pgadmin4 to connect to the servers, I
> also had to set `PGPASSFILE` in my Helm chart to make this work.
>
> This seems like another good ticket, no? I know where to add them and I'll
> put a patch in place, but I could sure use a little bit of guidance on the
> copy portion of the documentation. I know why it works for me, but would
> anyone conceivably use this in a non-Dockerized deployment?
>
> Thanks,
> Andrew
>
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
From | Date | Subject | |
---|---|---|---|
Next Message | Aditya Toshniwal | 2019-06-28 11:03:29 | [pgAdmin][RM4407] White page on PG admin 4.9 when locale is French |
Previous Message | Dave Page | 2019-06-27 14:57:23 | Re: change to Docker entrypoint.sh |