Re: PostgreSQL - HA Cluster / Etcd Issue
| От | Mike Artz |
|---|---|
| Тема | Re: PostgreSQL - HA Cluster / Etcd Issue |
| Дата | |
| Msg-id | CA+pG8ePE+KGS_x66P_zn=qM3Occ2N8UKtest8yrmeBH=2_4fTw@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: PostgreSQL - HA Cluster / Etcd Issue (SOzcn <selahattinozcnma@gmail.com>) |
| Список | pgsql-admin |
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@gmail.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@elevated-dev.com> şunu yazdı:This is a PostgreSQL mailing list, and your question has nothing to do with PostgreSQL.
--
Scott Ribe
scott_ribe@elevated-dev.com
https://www.linkedin.com/in/scottribe/
> On Aug 20, 2025, at 1:40 AM, SOzcn <selahattinozcnma@gmail.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
В списке pgsql-admin по дате отправления: