k0s-cluster/manifests/weed-pg.yaml

32 lines
599 B
YAML

apiVersion: postgresql.cnpg.io/v1
kind: Cluster
metadata:
name: weed-pg
namespace: weed
spec:
instances: 2
bootstrap:
initdb:
database: weed
owner: weed
secret:
name: weed-pg-secret
postInitApplicationSQL:
- |
CREATE TABLE IF NOT EXISTS filemeta (
dirhash BIGINT NOT NULL,
name VARCHAR(766) NOT NULL,
directory TEXT NOT NULL,
meta BYTEA,
PRIMARY KEY (dirhash, name)
);
- ALTER TABLE filemeta OWNER to weed;
storage:
size: 4Gi
storageClass: openebs-hostpath