Question

How to install pgAdmin 4 as an app platform component

Posted August 18, 2021 103 views
PostgreSQLDigitalOcean App Platform

I want to use pgAdmin 4 as a component in my app platform application. I created the app and used the image dpage/pgadmin4 from Docker Hub. I set the route to: /pgadmin in the component settings.

However, when I visit my.app/pgadmin, pgAdmin redirects me to my.app/login?next=%2F (where %2F encodes /).

I’m not sure if the app platform proxy is supposed to automatically rewrite the redirects by prepending the /pgadmin/ part or if there’s configuration I need to do in the pgAdmin to do that. I tried to find a configuration to change in pgAdmin and I couldn’t find one. According to their documentation, it should work automatically through the X-Forwarded-* HTTP headers.

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
1 answer

Hi @hashemi

I don’t think this will work with App Platform currently. PGAdmin4 requires a custom header which we don’t support, though it is on our roadmap.

From the PGAdmin docs:

If you wish to host pgAdmin under a subdirectory rather than on the root of the server, you must specify the location and set the X-Script-Name header which tells the pgAdmin container how to rewrite paths…