Re: PostgreSQL - HA Cluster / Etcd Issue

From: SOzcn <selahattinozcnma(at)gmail(dot)com>
To: Ozgur Kulu <kuluozgur(at)gmail(dot)com>
Cc: Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: PostgreSQL - HA Cluster / Etcd Issue
Date: 2025-08-20 22:17:03
Message-ID: CAJyV5AarrGaOU_woMEyAAmypG_xbAFW64e3YPFdw4zk3m4DpRw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello Ozgur,

Thanks for the reply.

If i up to etcd size from 2 to 8 GB it's make much problem but if defrag is
fix the "no space" issue can you share your experience? By example is it
spent too much rss etc. and are you doing that with cronjob or manuel. As i
know if etcd went to error with "no space" defrag methot also doesn't work.

Have a nice day.

Ozgur Kulu <kuluozgur(at)gmail(dot)com>, 20 Ağu 2025 Çar, 19:51 tarihinde şunu
yazdı:

> Hi there,
>
> Etcd database should be extended from 2 gb to 8gb. On the other hand, you
> can use defrag or again created the etcd db.
>
> Have a nice day,
>
> 20 Ağu 2025 Çar 10:40 tarihinde SOzcn <selahattinozcnma(at)gmail(dot)com> şunu
> yazdı:
>
>> 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

Browse pgsql-admin by date

  From Date Subject
Next Message Edwin UY 2025-08-21 07:03:09 SHELL Script to Compare Database Tables / Indexes / Constraints
Previous Message Ozgur Kulu 2025-08-20 16:51:36 Re: PostgreSQL - HA Cluster / Etcd Issue