Questions tagged [stolon]

Stolon is a cloud-native PostgreSQL manager for PostgreSQL high availability. It's cloud native, because it'll let you keep a highly available PostgreSQL inside your containers (Kubernetes integration), but also on every other kind of infrastructure (cloud IaaS, old style infrastructures, etc.)

6 questions
4
votes
1 answer

EOFException: null when using postgresql and stolon

We are getting this error: Caused by: org.postgresql.util.PSQLException: An I/O error occurred while sending to the backend. at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:327) at…
rgomesf
  • 702
  • 1
  • 10
  • 20
2
votes
1 answer

Kubernetes: Databases & DB Users

We are planning to use Kube for Postgres deployments. Our applications will be microservices with separated schema (or logical database). For security sake, we'd like to have separate users for each schema/logical_db. I suppose that the…
malejpavouk
  • 4,297
  • 6
  • 41
  • 67
1
vote
0 answers

pg_cron fails to execute transaction block

I have 5 jobs which contain a transaction block (similar code just modifying different tables) which get executed through pg_cron background workers and are passed as a naked string to scheduler. The blocks consist of BEGIN;(some queries)END; and…
nzivkovic
  • 11
  • 2
0
votes
0 answers

Liquibase with stolon via ansible - what is the right way to apply changes

If I have stolon cluster on let's say 3 hosts what is the right way to apply liquibase changes? Should I always choose master-node host? And what will happen if I choose replica host instead of master? What will happen if I try to run the same…
0
votes
0 answers

How to restart postgres sorintlab/stolon deployed on kubernetes cluster

I updated some configurations for Postgres sorintlab/stolon deployed on kubernetes cluster and trying to restart it, I couldn't find a clear instruction for doing it.
Eslam Ali
  • 101
  • 5
0
votes
1 answer

How to find stolon version

Hi I am new to infra related work. I am asked to copy 0.14.0 version of stolon binary files like stolonctl, stolon-keeper, stolon-proxy and stolon-sentinal to our postgresHa docker-container. I created a new container using the files in git hub…
beginner
  • 59
  • 5