Installing PostgreSQL Operator
Installing
The following assumes the proper prerequisites are satisfied we can now install the PostgreSQL Operator.
The commands should be run in the directory where the Crunchy PostgreSQL Operator
playbooks are stored. See the installers/ansible
directory in the Crunchy PostgreSQL Operator
project for the inventory file, values file, main playbook and ansible roles.
Installing on Linux
On a Linux host with Ansible installed we can run the following command to install the PostgreSQL Operator:
ansible-playbook -i /path/to/inventory.yaml --tags=install --ask-become-pass main.yml
Installing on macOS
On a macOS host with Ansible installed we can run the following command to install the PostgreSQL Operator.
ansible-playbook -i /path/to/inventory.yaml --tags=install --ask-become-pass main.yml
Installing on Windows Ubuntu Subsystem
On a Windows host with an Ubuntu subsystem we can run the following commands to install the PostgreSQL Operator.
ansible-playbook -i /path/to/inventory.yaml --tags=install --ask-become-pass main.yml
Verifying the Installation
This may take a few minutes to deploy. To check the status of the deployment run the following:
# Kubernetes
kubectl get deployments -n <NAMESPACE_NAME>
kubectl get pods -n <NAMESPACE_NAME>
# OpenShift
oc get deployments -n <NAMESPACE_NAME>
oc get pods -n <NAMESPACE_NAME>
Configure Environment Variables
After the Crunchy PostgreSQL Operator has successfully been installed we will need
to configure local environment variables before using the pgo
client.
To configure the environment variables used by pgo
run the following command:
Note: <PGO_NAMESPACE>
should be replaced with the namespace the Crunchy PostgreSQL
Operator was deployed to.
cat <<EOF >> ~/.bashrc
export PGOUSER="${HOME?}/.pgo/<PGO_NAMESPACE>/pgouser"
export PGO_CA_CERT="${HOME?}/.pgo/<PGO_NAMESPACE>/client.crt"
export PGO_CLIENT_CERT="${HOME?}/.pgo/<PGO_NAMESPACE>/client.crt"
export PGO_CLIENT_KEY="${HOME?}/.pgo/<PGO_NAMESPACE>/client.key"
export PGO_APISERVER_URL='https://127.0.0.1:8443'
EOF
Apply those changes to the current session by running:
source ~/.bashrc
Verify pgo
Connection
In a separate terminal we need to setup a port forward to the Crunchy PostgreSQL Operator to ensure connection can be made outside of the cluster:
# If deployed to Kubernetes
kubectl port-forward -n pgo svc/postgres-operator 8443:8443
# If deployed to OpenShift
oc port-forward -n pgo svc/postgres-operator 8443:8443
You can subsitute pgo
in the above examples with the namespace that you
deployed the PostgreSQL Operator into.
On a separate terminal verify the PostgreSQL client can communicate with the Crunchy PostgreSQL Operator:
pgo version
If the above command outputs versions of both the client and API server, the Crunchy PostgreSQL Operator has been installed successfully.