{"id":303,"date":"2023-07-19T07:07:29","date_gmt":"2023-07-19T07:07:29","guid":{"rendered":"http:\/\/www.adartis.de\/?p=303"},"modified":"2023-07-19T07:15:48","modified_gmt":"2023-07-19T07:15:48","slug":"postgres-operator","status":"publish","type":"post","link":"https:\/\/www.adartis.de\/?p=303","title":{"rendered":"Postgres-operator"},"content":{"rendered":"\n<p>Der Operator wird mithilfe von <a href=\"https:\/\/github.com\/zalando\/postgres-operator\">Zalandos GitHub<\/a> installiert.<\/p>\n\n\n\n<p>Die komplette Anleitung dieses Operators findet man in <a href=\"https:\/\/postgres-operator.readthedocs.io\/en\/latest\/\">diese Webseite<\/a>.<\/p>\n\n\n\n<p>Pulle die Repo, pr\u00fcfe die value.yaml Datei in \u201ccharts\/postgres-operator\/values.yaml\u201d und dann f\u00fchre durch Helm aus:<\/p>\n\n\n\n<div class=\"wp-block-group has-background has-small-font-size is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#e9e9ea;line-height:1\">\n<p><em># Operator itself<\/em> <\/p>\n\n\n\n<p>$ helm upgrade &#8211;install postgres-operator -n postgres &#8211;create-namespace .\/charts\/postgres-operator<\/p>\n\n\n\n<p> <em># operator UI<\/em> <\/p>\n\n\n\n<p style=\"line-height:2.1\">$ helm upgrade &#8211;install postgres-operator-ui -n postgres &#8211;create-namespace .\/charts\/postgres-operator-ui<\/p>\n<\/div>\n\n\n\n<p>Warte bis postgres-operator ausgef\u00fchrt ist und zun\u00e4chst pr\u00fcfe, ob es Up ist:<\/p>\n\n\n\n<div class=\"wp-block-group has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#eaeaea;line-height:1.2\">\n<p><code>$ kubectl --namespace=postgres get pods -l\"app.kubernetes.io\/name=postgres-operator\" <\/code><\/p>\n\n\n\n<p><code>$ kubectl --namespace=postgres get pods -l\"app.kubernetes.io\/name=postgres-operator-ui\"<\/code><\/p>\n<\/div>\n\n\n\n<p>Wenn alles OK ist, mach mit cluster selbst weiter und f\u00fchre die passende Manifest in dieser Pfad \u201cpostgres-operator\/manifests\/\u201c aus.<\/p>\n\n\n\n<p>Danach mach ein Ingress f\u00fcr die UI:<\/p>\n\n\n\n<div class=\"wp-block-group has-background is-layout-constrained wp-block-group-is-layout-constrained\" style=\"background-color:#e4e5e6\">\n<p>kind: Ingress<br>apiVersion: networking.k8s.io\/v1<br>metadata:<br>name: postgres-operator<br>namespace: postgres<br>annotations:<br>traefik.ingress.kubernetes.io\/router.entrypoints: web<\/p>\n\n\n\n<p>spec:<br>ingressClassName: traefik<br>rules:<br>&#8211; host: pgcluster.apps.rancher.adartish.de<br>http:<br>paths:<br>&#8211; path: \/<br>pathType: Prefix<br>backend:<br>service:<br>name: postgres-operator-ui<br>port:<br>number: 80<\/p>\n<\/div>\n\n\n\n<p>Um Clusters DNS Zone zu definieren, \u00e4ndere \u201c<code>db_hosted_zone<\/code>\u201c in values.yaml Datei.<\/p>\n\n\n\n<p>Cluster Backup kann nicht auf Minio gespeichert werden!<\/p>\n\n\n\n<p>Ressourcen:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/wiki.postgresql.org\/wiki\/Replication,_Clustering,_and_Connection_Pooling\">Replication, Clustering, and Connection Pooling &#8211; PostgreSQL wiki<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/postgres-operator.readthedocs.io\/en\/latest\/\">Home &#8211; Postgres Operator<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/github.com\/zalando\/postgres-operator\/blob\/master\/docs\/quickstart.md#deployment-options\">https:\/\/github.com\/zalando\/postgres-operator\/blob\/master\/docs\/quickstart.md#deployment-options<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Der Operator wird mithilfe von Zalandos GitHub installiert. Die komplette Anleitung dieses Operators findet man [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-303","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.adartis.de\/index.php?rest_route=\/wp\/v2\/posts\/303","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.adartis.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.adartis.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.adartis.de\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.adartis.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=303"}],"version-history":[{"count":3,"href":"https:\/\/www.adartis.de\/index.php?rest_route=\/wp\/v2\/posts\/303\/revisions"}],"predecessor-version":[{"id":306,"href":"https:\/\/www.adartis.de\/index.php?rest_route=\/wp\/v2\/posts\/303\/revisions\/306"}],"wp:attachment":[{"href":"https:\/\/www.adartis.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=303"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.adartis.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=303"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.adartis.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=303"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}