Re: passwords enabled by default

Поиск
Список
Период
Сортировка
От Dave Page
Тема Re: passwords enabled by default
Дата
Msg-id CA+OCxoy28r9zWG5u1jagf-6B4274H0A5P4iU_rJ4jr6n7t-O8A@mail.gmail.com
обсуждение исходный текст
Ответ на passwords enabled by default  (Andrew Coleman <penguincoder@gmail.com>)
Ответы Re: passwords enabled by default  (Fahar Abbas <fahar.abbas@enterprisedb.com>)
Список 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@gmail.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

В списке pgadmin-hackers по дате отправления:

Предыдущее
От: Dave Page
Дата:
Сообщение: Re: change to Docker entrypoint.sh
Следующее
От: Aditya Toshniwal
Дата:
Сообщение: [pgAdmin][RM4407] White page on PG admin 4.9 when locale is French