public inbox for [email protected]
help / color / mirror / Atom feedFrom: Mike Artz <[email protected]>
To: SOzcn <[email protected]>
Cc: Scott Ribe <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: PostgreSQL - HA Cluster / Etcd Issue
Date: Wed, 20 Aug 2025 09:03:08 -0500
Message-ID: <CA+pG8ePE+KGS_x66P_zn=qM3Occ2N8UKtest8yrmeBH=2_4fTw@mail.gmail.com> (raw)
In-Reply-To: <CAJyV5AYSSXqTycSqLauTzZwk4EKa4nKM3k7hig2cs-5X9rDm3w@mail.gmail.com>
References: <CAJyV5AaBZy=b=HzjnW-KiTj2_kvt5R0LW7-Cum5W_nYDwhqTzA@mail.gmail.com>
<[email protected]>
<CAJyV5AYSSXqTycSqLauTzZwk4EKa4nKM3k7hig2cs-5X9rDm3w@mail.gmail.com>
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 <[email protected]> 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 <[email protected]>
> şunu yazdı:
>
>> This is a PostgreSQL mailing list, and your question has nothing to do
>> with PostgreSQL.
>>
>> --
>> Scott Ribe
>> [email protected]
>> https://www.linkedin.com/in/scottribe/
>>
>>
>>
>> > On Aug 20, 2025, at 1:40 AM, SOzcn <[email protected]> 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
>>
>>
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected]
Subject: Re: PostgreSQL - HA Cluster / Etcd Issue
In-Reply-To: <CA+pG8ePE+KGS_x66P_zn=qM3Occ2N8UKtest8yrmeBH=2_4fTw@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox