odenio / pgpool-cloudsql

The PGPool-II PostgreSQL connection proxy with automatic discovery of Google CloudSQL backends
Apache License 2.0
8 stars 4 forks source link

How to authenticate gcloud cli #15

Open nishit130 opened 11 months ago

nishit130 commented 11 months ago

How do I authenticate gcloud cli for discovering read replicas. I couldn't find any variable for setting GOOGLE_APPLICATION_CREDENTIALS env.

n-oden commented 11 months ago

Hi @nis130 -- at the moment, only the default application credentials provided by the GCE/GKE metadata providers are supported: you'll need to configure either your instance or workload identity to have cloudsql admin read API privileges.

That said, authenticating using GOOGLE_APPLICATION_CREDENTIALS is not an unreasonable ask -- if you can describe your use case in a bit more detail I can try to get the work necessary to support it scheduled for sometime before the end of the year. And of course, I'll happily review any pull requests. :)