On Thu, Jul 23, 2020 at 9:59 AM Dave Page <dp...@pgadmin.org> wrote: > Hi > > On Thu, Jul 23, 2020 at 12:57 AM Zoltan Albert <znalb...@gmail.com> wrote: > >> I'm trying to use docker compose to spin up postgres and pgAdmin >> services, and the only sticking point is a minor one: I can't seem to get >> the PassFile to work. >> >> I wonder if it's not possible because of the following note at the bottom >> this page of the pgAdmin docs >> https://www.pgadmin.org/docs/pgadmin4/4.23/server_dialog.html: >> >> ``` >> >> Note >> >> The password file option is only supported when pgAdmin is using libpq >> v10.0 or later to connect to the server. >> ``` >> > That won't be an issue if you're using dpage/pgadmin4 (or any of the > installers/packages built by the pgAdmin team). > > My guess would be that you've not got the permissions or ownership of the > pgpassfile correct so libpq is just ignoring it. It needs to be mode 0600 > and owned by 5050:5050. > > I have no idea how you make that happen in Docker Compose though. >
It turns out that others have got this to work though - you can find an example here: https://github.com/asaikali/docker-compose-postgres -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EDB: http://www.enterprisedb.com
