Using pgo client with OpenShift operator?

[Lars Kellogg-Stedman]

I've installed the "Crunchy Postgres for Kubernetes" operator on our OpenShift 4.8 cluster. Everything seems to work great, but I was interested in using the "pgo" command line tool for interacting with database cluster, and I'm not sure what I should be using for the value of PGO_APISERVER_URL.

The operator only installs a single pod ("pgo-5bc75457fb-h9mn9"), and no services.

With an active database cluster, I see the following services, none of which appear to be an api server:

example-cluster-ha          ClusterIP   172.30.243.1     <none>        5432/TCP   14m

example-cluster-ha-config   ClusterIP   None             <none>        <none>     14m

example-cluster-pgbouncer   ClusterIP   172.30.70.80     <none>        5432/TCP   14m

example-cluster-pods        ClusterIP   None             <none>        <none>     14m

example-cluster-primary     ClusterIP   None             <none>        5432/TCP   14m

example-cluster-replicas    ClusterIP   172.30.203.131   <none>        5432/TCP   14m

With what service is the cli meant to interact?

[Jonathan S. Katz]

There is currently no CLI tool for v5 of PGO, but there may be one in a future release.

What kinds of things are you looking to do with a CLI?

Thanks,

Jonathan

Jonathan S. Katz

VP Platform Engineering

Crunchy Data
Enterprise PostgreSQL 

www.crunchydata.com

[Lars Kellogg-Stedman]

On Wed, 3 Nov 2021, Jonathan S. Katz wrote:
> There is currently no CLI tool for v5 of PGO, but there may be one in a future release.
> What kinds of things are you looking to do with a CLI?

I was mostly looking for a convenient command line method for checking
cluster status (and disk space) and perhaps triggering manual backups.
I'm probably just as happy without a specific tool; I had just come
across the pgo documentation and didn't realize it only applied to
earlier versions of the operator.

We generally manage our cluster via argocd and kustomize, so I'm
explicitly not looking for anything that modifies the configuration
(scaling, updates, etc).

--
Lars Kellogg-Stedman <la...@redhat.com>

[Jonathan S. Katz]

On Wed, Nov 3, 2021 at 9:43 AM Lars Kellogg-Stedman <la...@redhat.com> wrote:

On Wed, 3 Nov 2021, Jonathan S. Katz wrote:
> There is currently no CLI tool for v5 of PGO, but there may be one in a future release.
> What kinds of things are you looking to do with a CLI?

I was mostly looking for a convenient command line method for checking
cluster status (and disk space) and perhaps triggering manual backups.
I'm probably just as happy without a specific tool; I had just come
across the pgo documentation and didn't realize it only applied to
earlier versions of the operator.

Got it -- thanks that is helpful!

 

We generally manage our cluster via argocd and kustomize, so I'm
explicitly not looking for anything that modifies the configuration
(scaling, updates, etc).

ICYMI The updated docs are here: https://access.crunchydata.com/documentation/postgres-operator/v5/ 

Jonathan