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