public inbox for [email protected]
help / color / mirror / Atom feedFrom: SOzcn <[email protected]>
To: Scott Ribe <[email protected]>
Cc: Pgsql-admin <[email protected]>
Subject: Re: PostgreSQL - HA Cluster / Etcd Issue
Date: Wed, 20 Aug 2025 16:52:42 +0300
Message-ID: <CAJyV5AYSSXqTycSqLauTzZwk4EKa4nKM3k7hig2cs-5X9rDm3w@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <CAJyV5AaBZy=b=HzjnW-KiTj2_kvt5R0LW7-Cum5W_nYDwhqTzA@mail.gmail.com>
<[email protected]>
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]
Subject: Re: PostgreSQL - HA Cluster / Etcd Issue
In-Reply-To: <CAJyV5AYSSXqTycSqLauTzZwk4EKa4nKM3k7hig2cs-5X9rDm3w@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