[Question] Does high availability postgreSQL clusters support `hostpath` storage like etcd storage?

[microyahoo]

Hi, does high availability postgreSQL clusters support hostpath storage like etcd storage? For example, there have three nodes to setup HA cluster, and every node uses its local path as underlying storage, how to setup and configure it? Thanks.

[microyahoo]

Another questions:

1. what's relationship between postgres-operator and crunchy-containers?
2. I have noticed that latest release version is 4.7.4, but I meet the same issue, which recommends installing V5. Which is the latest release? @jkatz @cbandy

[andrewlecuyer]

Hi, does high availability postgreSQL clusters support hostpath storage like etcd storage? For example, there have three nodes to setup HA cluster, and every node uses its local path as underlying storage, how to setup and configure it? Thanks.

Yes, that should be possible. You can configure multiple instance sets under spec.instances - one for each PG replica - with each configured via the dataVolumeClaimSpec field to use any valid storage available in your environment (e.g. you could point each to various hostpath PV's available in your cluster, etc.).

See our documentation for creating a cluster for more details about defining the dataVolumeClaimSpec:

1. what's relationship between postgres-operator and crunchy-containers?

While the Crunchy Postgres Operator (postgres-operator) is Crunchy's fully open-source PostgreSQL operator, the Crunchy Container Suite (crunchy-containers) provides the various components available for use with the Crunchy Postgres Operator, as described in the Components and Compatibility documentation.

2. I have noticed that latest release version is 4.7.4, but I meet the same https://github.com/CrunchyData/postgres-operator/issues/2602, which recommends installing V5. Which is the latest release?

You should install the latest v5 release: https://access.crunchydata.com/documentation/postgres-operator/latest/.