phpPGAdmin


lukas.klein@...
 

Hello together,


is there an How-To install phpPGAdmin on my local client.

I try to connect my Windows Client to a PostgreSQL in the CF PaaS Cloud.


Is phpPGAdmin the only Tool to access and manage an PostgreSQL in CF PaaS Cloud or are there other solutions?

Is there also an How-To or Tutorial fot these PostgreSQL-Management Tool ?


Thank you!!

Lukas Klein



If you are not the addressee, please inform us immediately that you have received this e-mail by mistake, and delete it. We thank you for your support.


Chip Childers <cchilders@...>
 

Lukas,

The tools used to connect to various backing services (databases, cache clusters, etc...) are going to be specific to the service itself. The CF community doesn't work on anything like that. I'd suggest looking for help installing PostgreSQL management tools from the project / product that you are trying to install. Last resort: If you use a commercial distribution of Cloud Foundry, you might consider looking at their support options for help.

Chip Childers
Executive Director
Cloud Foundry Foundation


On Tue, Mar 30, 2021 at 9:47 AM <lukas.klein@...> wrote:

Hello together,


is there an How-To install phpPGAdmin on my local client.

I try to connect my Windows Client to a PostgreSQL in the CF PaaS Cloud.


Is phpPGAdmin the only Tool to access and manage an PostgreSQL in CF PaaS Cloud or are there other solutions?

Is there also an How-To or Tutorial fot these PostgreSQL-Management Tool ?


Thank you!!

Lukas Klein



If you are not the addressee, please inform us immediately that you have received this e-mail by mistake, and delete it. We thank you for your support.


Daniel Jones
 

Hi Lukas,

The challenge you face is that the PostgreSQL instance that is visible in `cf services` may not be accessible directly from your workstation. It might not even be running in Cloud Foundry - CF doesn't actually know how to create a PostgreSQL instance, and instead asks a 'service broker' to create an instance.

Luckily the fine people at UK Government Digital Services made a CLI plugin that may help: https://github.com/alphagov/paas-cf-conduit

Presumably this tool connects from your workstation to an app instance, and then connects to the PostgreSQL instance from there. You should be able to use whatever client you like using this tunnel.

I'd invite you to think about the use case you have, and whether you really should be connecting to the database from your workstation. I can imagine it being useful for debugging, and I can also imagine it being dangerous in a production environment for security/privacy/stability reasons.

Regards,
Daniel 'Deejay' Jones - Managing Director
+44 (0)79 8000 9153
EngineerBetter Ltd - More than cloud platform specialists


On Tue, 30 Mar 2021 at 15:47, <lukas.klein@...> wrote:

Hello together,


is there an How-To install phpPGAdmin on my local client.

I try to connect my Windows Client to a PostgreSQL in the CF PaaS Cloud.


Is phpPGAdmin the only Tool to access and manage an PostgreSQL in CF PaaS Cloud or are there other solutions?

Is there also an How-To or Tutorial fot these PostgreSQL-Management Tool ?


Thank you!!

Lukas Klein



If you are not the addressee, please inform us immediately that you have received this e-mail by mistake, and delete it. We thank you for your support.