Re: PostgreSQL - HA Cluster / Etcd Issue

Are you saying that you already have a compaction job running (e.g.

etcdctl compact $(etcdctl endpoint status --write-out=json | jq -r
'.[0].Status.header.revision - 1000')

or similar), but you’re hoping there’s a parameter in etcd itself to handle
that scheduling?

On Wed, Aug 20, 2025 at 8:53 AM SOzcn <selahattinozcnma(at)gmail(dot)com> wrote:

> 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
>>
>>