Getting Started

Installation

If you have not installed PGO, the Postgres Operator, yet, we recommend you take a look at our quickstart or the installation sections.

Customizing an Installation

How to customize a PGO installation is a lengthy topic. The details are covered in the installation section, as well as a list of all the configuration variables available.

Setup the pgo Client

This tutorial will be using the pgo client to interact with the Postgres Operator. Please follow the instructions in the quickstart or the installation sections for how to configure the pgo client.

The Postgres Operator and pgo client are designed to work in a multi-namespace deployment environment and many pgo commands require that the namespace flag (-n) are passed into it. You can use the PGO_NAMESPACE environmental variable to set which namespace a pgo command can use. For example:

export PGO_NAMESPACE=pgo
pgo show cluster --all

would show all of the PostgreSQL clusters deployed to the pgo namespace. This is equivalent to:

pgo show cluster -n pgo --all

(Note: -n takes precedence over PGO_NAMESPACE.)

For convenience, we will use the pgo namespace created as part of the quickstart in this tutorial. In the shell that you will be executing the pgo commands in, run the following command:

export PGO_NAMESPACE=pgo

Next Steps

Before proceeding, please make sure that your pgo client setup can communicate with your PGO Deployment. In a separate terminal window, set up a port forward to your PostgreSQL Operator:

kubectl port-forward -n pgo svc/postgres-operator 8443:8443

The pgo version command is a great way to check connectivity with the Postgres Operator, as it is a very simple, safe operation. Try it out:

pgo version

If it is working, you should see results similar to:

pgo client version 4.5.8
pgo-apiserver version 4.5.8

Note that the version of the pgo client must match that of the PostgreSQL Operator.

You can also use the pgo version command to check the version specifically for the pgo client. This command only runs locally, i.e. it does not make any requests to the PostgreSQL Operator. For example:

pgo version --client

which yields results similar to:

pgo client version 4.5.8

Alright, we’re now ready to start our journey with PGO!