Re: PostgreSQL - HA Cluster / Etcd Issue

From: SOzcn <selahattinozcnma(at)gmail(dot)com>
To: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: PostgreSQL - HA Cluster / Etcd Issue
Date: 2025-08-20 13:52:42
Message-ID: CAJyV5AYSSXqTycSqLauTzZwk4EKa4nKM3k7hig2cs-5X9rDm3w@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

This is high availability environment and etcd is one management tools of
them . Many PostgreSQL managed by this architec. I advice to you research.
Etcs - Patrono - Postgresql- Haproxy- Keepalived. Anyway if you doesn't
have experience of it, that's ok.

20 Ağu 2025 Çar 15:46 tarihinde Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
şunu yazdı:

> This is a PostgreSQL mailing list, and your question has nothing to do
> with PostgreSQL.
>
> --
> Scott Ribe
> scott_ribe(at)elevated-dev(dot)com
> https://www.linkedin.com/in/scottribe/
>
>
>
> > On Aug 20, 2025, at 1:40 AM, SOzcn <selahattinozcnma(at)gmail(dot)com> wrote:
> >
> > Hello,
> >
> > In my database architecture, I use Etcd, Patroni, HAProxy, and
> Keepalived.
> >
> > Although many things in this architecture work as expected, Etcd
> encounters the error "memberID:5960773920904691185 alarm:NOSPACE" once
> every 2 or 3 months. The root cause is that the database size reaches the
> specified limit and Etcd does not clean it up through rotation. I am aware
> of this, but despite reviewing the maintenance documentation, I could not
> find the most appropriate parameter values for this rotation. I am sharing
> an example of my own Etcd configuration below. I kindly ask you to share
> your experience on this matter. I am kinda stuck on this issue.
> >
> > In particular, is it possible to schedule the parameter that performs
> this cleanup with a time setting? For example, can I tell it to run the
> compact operation at around 01:00 AM?
> >
> > Best regards.
> >
> >
> > [Unit]
> > Description=etcd service
> > Documentation=https://github.com/etcd-io/etcd
> > After=network.target
> >
> > [Service]
> > User=etcd
> > Type=notify
> > ExecStart=/usr/local/sbin/etcd \
> > --name etcd1 \
> > --data-dir=/etc/etcd \
> > --initial-advertise-peer-urls=http://10.115.208.168:2380 \
> > --listen-peer-urls=http://192.168.1.1:2380 \
> > --listen-client-urls=http://192.168.1.1:2379,http://127.0.0.1:2379 \
> > --advertise-client-urls=192.168.1.1:2379 \
> > --initial-cluster-token="etcd-cluster" \
> > --initial-cluster="etcd1=http://192.168.1.1:2380,etcd2=
> http://192.168.1.2:2380,etcd3=http://3:2380" \
> > --initial-cluster-state="new" \
> > --log-level="error"
> >
> > [Install]
> > WantedBy=multi-user.target
>
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mike Artz 2025-08-20 14:03:08 Re: PostgreSQL - HA Cluster / Etcd Issue
Previous Message Scott Ribe 2025-08-20 12:46:40 Re: PostgreSQL - HA Cluster / Etcd Issue