spilo | Highly available elephant herd: HA PostgreSQL cluster using Docker | Continuous Deployment library

by zalando Python Version: 3.0-p1 License: Apache-2.0

X-Ray Key Features Code Snippets(1)Community Discussions(4)Vulnerabilities Install Support

kandi X-RAY | spilo Summary

spilo is a Python library typically used in Devops, Continuous Deployment, PostgresSQL, Docker applications. spilo has no bugs, it has no vulnerabilities, it has a Permissive License and it has medium support. However spilo build file is not available. You can download it from GitHub.

Highly available elephant herd: HA PostgreSQL cluster using Docker

Support

Quality

Security

License

Reuse

Support

spilo has a medium active ecosystem.

It has 1151 star(s) with 308 fork(s). There are 49 watchers for this library.

It had no major release in the last 12 months.

There are 28 open issues and 330 have been closed. On average issues are closed in 69 days. There are 11 open pull requests and 0 closed requests.

It has a neutral sentiment in the developer community.

The latest version of spilo is 3.0-p1

Quality

spilo has 0 bugs and 0 code smells.

Security

spilo has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

spilo code analysis shows 0 unresolved vulnerabilities.

There are 0 security hotspots that need review.

License

spilo is licensed under the Apache-2.0 License. This license is Permissive.

Permissive licenses have the least restrictions, and you can use them in most projects.

Reuse

spilo releases are available to install and integrate.

spilo has no build file. You will be need to create the build yourself to build the component from source.

It has 2987 lines of code, 168 functions and 14 files.

It has high code complexity. Code complexity directly impacts maintainability of the code.

Top functions reviewed by kandi - BETA

kandi has reviewed spilo and discovered the below as its top functions. This is intended to give you an instant insight into spilo implemented functionality, and help decide if they suit your requirements.

Get placeholders
Get instance metadata
Get the listen IP address
Set the value in placeholders
Write a Wale environment
Write configuration to file
Change the owner of a resource
Rsync replica
Kill patroni
Prepare new pgdata
Setup package
Create the ssh tunnel
Write a cron job
Write ssl certificates
Get DCS configuration
Get metadata for instance
Upload file to S3
Determine provider
Drops obsolete objects from the cluster
Performs a point - in - time recovery
Rebuild statistics
Create log environment
Read configuration file
Parse command line options
Parse command line options
Write REST API certificates
Compress postgresql log file

Get all kandi verified functions for this library.

spilo Key Features

No Key Features are available at this moment for spilo.

spilo Examples and Code Snippets

spilo ,License

Rust

Lines of Code : 15

License : Strong Copyleft (AGPL-3.0)

Copy

spilo - a minimalistic IRC bouncer
Copyright (C) 2018 Aaron Weiss

This program is free software: you can redistribute it and/or modify
it under the terms of the GNU Affero General Public License as published by
the Free Software Foundation, either v

Community Discussions

Trending Discussions on spilo

How to cancel a broken StatefulSets rolling update?

Pod name resolution for StatefulSet doesn't work

Replica node never recover after rewind in Zalando operator

postgres-operator Failed to connect to database

QUESTION

How to cancel a broken StatefulSets rolling update?

Asked 2021-Dec-14 at 13:42

I have a PostgreSQL Kubernetes Service based on Patroni/Spilo. This Kubernetes service deploys a cluster of three PostgreSQL pods + three Etcd pods. During maintenance, I had a failure and I wasn't able to restore the old configuration that worked fine before the rolling update.

I searched for documentation and it seems StatefulSets doesn't support rollbacks as deployment. I found this thread that references this doc.

To be honest, however, I didn't understand how to proceed.

My cluster has the following pods:

...

ANSWER

Answered 2021-Dec-14 at 13:42

To undo changes that have been made, first checkout the rollout history kubectl rollout history sts -n .

Get more details about a revision kubectl rollout history sts --revision -n .

Undo the changes kubectl rollout undo sts --to-revision -n

Source https://stackoverflow.com/questions/70346644

QUESTION

Pod name resolution for StatefulSet doesn't work

Asked 2021-Oct-27 at 11:14

I have the following Kubernetes YAML with a StatefulSet I use to deploy a PostgreSQL cluster with Patroni. However, the question is relative to how Kubernetes registers Pod names in CoreDNS.

According to this documentation in the Stable Network ID section if I create a Headless service called spilodemo-svc for my Pods I can access them using the short hostname (podname.servicename):

...

ANSWER

Answered 2021-Oct-27 at 11:14

After almost three days of tests, I found a solution. The solution depends on two things:

how Kubernetes works;
how Patroni works.

How Kubernetes Works

When you create a StatefulSet deployment (but this is true also for Deployment), let's say with 3 pods, Kubernetes register in CoreDNS three DNS names:

Source https://stackoverflow.com/questions/69577282

QUESTION

Replica node never recover after rewind in Zalando operator

Asked 2021-Mar-15 at 22:53

I making a POC, in my test I killed the primary node, other node take the primary role, the new replica rewind.... but dead whit this messages:

...

ANSWER

Answered 2021-Mar-15 at 22:53

After go inside the docker, exec a patronictl -c ... reinit, wait and your node will be online again....❗

Source https://stackoverflow.com/questions/66642931

QUESTION

postgres-operator Failed to connect to database

Asked 2020-May-17 at 13:14

I have installed https://github.com/zalando/postgres-operator on my K8S cluster on namespace postgres

...

ANSWER

Answered 2020-May-17 at 13:14

It seems you missed out the database owner rights and the role for the application, here is the correct manifest:

Source https://stackoverflow.com/questions/61850049

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install spilo

You can download it from GitHub.
You can use spilo like any standard Python library. You will need to make sure that you have a development environment consisting of a Python distribution including header files, a compiler, pip, and git installed. Make sure that your pip, setuptools, and wheel are up to date. When using pip it is generally recommended to install packages in a virtual environment to avoid changes to the system.

Support

For any new features, suggestions and bugs create an issue on GitHub. If you have any questions check and ask questions on community page Stack Overflow .

Find more information at: