Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uojPR-009Aeg-NI for pgsql-admin@arkaria.postgresql.org; Wed, 20 Aug 2025 14:03:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1uojPR-008d62-4E for pgsql-admin@arkaria.postgresql.org; Wed, 20 Aug 2025 14:03:25 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uojPQ-008d5t-L6 for pgsql-admin@lists.postgresql.org; Wed, 20 Aug 2025 14:03:25 +0000 Received: from mail-lf1-x134.google.com ([2a00:1450:4864:20::134]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uojPO-000v29-2T for pgsql-admin@lists.postgresql.org; Wed, 20 Aug 2025 14:03:24 +0000 Received: by mail-lf1-x134.google.com with SMTP id 2adb3069b0e04-55ce528a0f5so6695063e87.3 for ; Wed, 20 Aug 2025 07:03:22 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1755698601; x=1756303401; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=gwLg3RkuthAYi2xLOz5eZJzde6PXsTkUt/IL/A0JXR4=; b=UV4d7yxAW2Q5fGrgikZceBrKpfQePzKAhviJnBOjw/dwpHmTqVCWhT4QWgXq5ZbOlY oScB8P2vnGq816N3T0dpUm7Qmf2xyrSzN/PR5v8Q9FrzSXTukPiMqtRJvYWt2v1tGV5l K0+zVZBX3ySqrIST2oWzkvwxB1Hdi05PvyGZJ4HjJtWSMwrJHt5WCJCtKMfujmeDLvgD pDsf0O/OEhg49UKeNsKOuC5nZbblY/rWccmudhiOqoRFRX9W1NuTc5Se3+c59FV02Drh /Zz9Nw6awZgK4fsNI3H3bVMaDJN2XkGI/rtD2LCA2KhlZx+l1DECnzTgw94pTyZJGZ5d 60mw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1755698601; x=1756303401; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=gwLg3RkuthAYi2xLOz5eZJzde6PXsTkUt/IL/A0JXR4=; b=rsdOfXRmd8CALZFAOmX0bRj3e3fT0PdFWKCAMmTmqEaD75MDEU5DKgMxG1G9pxHwnP XYTpMXAf3wHFfyICrWrVCbNQZQcWR/K54GqQqX/aW4ZI3uceWvkW6Ii22hDttzUBlViX 68EZZS3eSO2JuugPE+hn6Ms5op9NfVv7Gj9P5OBVBr/Oq4oWkUtvhJAstSdQ58M1w5+l cKNhHDedIVq8hZeXRhFZDe5xWamOaWNAkBxcyv5GtE9hbJyDflhnGt5XVxQqu2g5cHvV 2cnfXL6yxo2MAkQ1sybxlim8TJaQH/V+p3Z3ZLk7hsWJ3rEwZQqOZGUR+XR9peBS9+jQ q2bg== X-Forwarded-Encrypted: i=1; AJvYcCVzHEf1iHYli1o421hJbxC9/yJBZL4wnPndyRGLMrWauSGof7V2e2WeGEGySE5typInfWx4ltYvshnAYQ==@lists.postgresql.org X-Gm-Message-State: AOJu0Yy2CQzl9Gz22me9ZDORlF5cOFDBhjrxYksE6s8bfzcfv7zKcppP 3kNTBt4L655VTqrhNzQRlUYxqeGjnIDQRikitsQN30DZQtWE6zWRKd44v357HZSL6+7kvnuVSCH AqqIHzbbXUbMhf8kqO8NvEvuyBrXypJ1SAUNouhk= X-Gm-Gg: ASbGncvpeqjBQz/RCtnwuTZNnoDdRcxL4t3Py8+P0jGxbz/KFm53eKv8QdW8grTSrja mRBRKP/sQGbQSvviGH1dbquzSQgfUHG0vFyVeei/BhonGliGUO3KR+Cbeq5ab4qi0ef3qRY7Wf/ cKiXeQvO3lAhNCVN8JRQADXrbT8tXiWqSLa6UMA5H6SDpzxSEzk/4lwtRpBxiT8DZYaEd1DlC/M 9KYWIk= X-Google-Smtp-Source: AGHT+IGdYGqPIWDfQY8VP4Y0AnxHJG+liKHAVfyvri8xYhaJZ/P+RLwussbFPDmYHdYOvyd+ll3sgV0R49Lvy5rEc4s= X-Received: by 2002:a05:6512:2c89:b0:55b:95a1:9734 with SMTP id 2adb3069b0e04-55e06b92432mr796448e87.26.1755698600955; Wed, 20 Aug 2025 07:03:20 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Mike Artz Date: Wed, 20 Aug 2025 09:03:08 -0500 X-Gm-Features: Ac12FXzb6sab_TMqmDAkSzAW7eiE00MGadqgWPK2ADVZZo-LG-OmlrX-IGxMrr8 Message-ID: Subject: Re: PostgreSQL - HA Cluster / Etcd Issue To: SOzcn Cc: Scott Ribe , Pgsql-admin Content-Type: multipart/alternative; boundary="00000000000071544f063ccc6f08" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --00000000000071544f063ccc6f08 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Are you saying that you already have a compaction job running (e.g. etcdctl compact $(etcdctl endpoint status --write-out=3Djson | jq -r '.[0].Status.header.revision - 1000') or similar), but you=E2=80=99re hoping there=E2=80=99s a parameter in etcd = itself to handle that scheduling? On Wed, Aug 20, 2025 at 8:53=E2=80=AFAM SOzcn = 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=C4=9Fu 2025 =C3=87ar 15:46 tarihinde Scott Ribe > =C5=9Funu yazd=C4=B1: > >> 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=E2=80=AFAM, SOzcn 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 th= e >> specified limit and Etcd does not clean it up through rotation. I am awa= re >> of this, but despite reviewing the maintenance documentation, I could no= t >> find the most appropriate parameter values for this rotation. I am shari= ng >> 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=3Detcd service >> > Documentation=3Dhttps://github.com/etcd-io/etcd >> > After=3Dnetwork.target >> > >> > [Service] >> > User=3Detcd >> > Type=3Dnotify >> > ExecStart=3D/usr/local/sbin/etcd \ >> > --name etcd1 \ >> > --data-dir=3D/etc/etcd \ >> > --initial-advertise-peer-urls=3Dhttp://10.115.208.168:2380 \ >> > --listen-peer-urls=3Dhttp://192.168.1.1:2380 \ >> > --listen-client-urls=3Dhttp://192.168.1.1:2379,http://127.0.0.1:2379= \ >> > --advertise-client-urls=3D192.168.1.1:2379 \ >> > --initial-cluster-token=3D"etcd-cluster" \ >> > --initial-cluster=3D"etcd1=3Dhttp://192.168.1.1:2380,etcd2=3D >> http://192.168.1.2:2380,etcd3=3Dhttp://3:2380" \ >> > --initial-cluster-state=3D"new" \ >> > --log-level=3D"error" >> > >> > [Install] >> > WantedBy=3Dmulti-user.target >> >> --00000000000071544f063ccc6f08 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable

Are you saying that you already have a compaction job r= unning (e.g.

etcdctl compact $(etcdctl endpoi=
nt status --write-out=3Djson | jq -r '=
;.[0].Status.header.revision - 1000')

or similar), but you=E2=80=99re hoping there=E2=80=99s a parameter in et= cd itself to handle that scheduling?




On Wed, Aug 20, 2025 at 8:53=E2=80=AFAM SOzcn <selahattinozcnma@gmail.com> wrote:
=
T= his is high availability environment and etcd is one management tools of th= em . Many PostgreSQL managed by this architec. I advice to you research. Et= cs - Patrono - Postgresql- Haproxy- Keepalived. Anyway if you doesn't h= ave experience of it, that's ok.=C2=A0

20 A=C4=9Fu 2025 =C3=87ar 15:46 t= arihinde Scott Ribe <scott_ribe@elevated-dev.com> =C5=9Funu yazd=C4=B1:
=
This is a PostgreSQ= L 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=E2=80=AFAM, SOzcn <selahattinozcnm= a@gmail.com> wrote:
>
> Hello,
>
> In my database architecture, I use Etcd, Patroni, HAProxy, and Keepali= ved.
>
> Although many things in this architecture work as expected, Etcd encou= nters 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 f= ind the most appropriate parameter values for this rotation. I am sharing a= n example of my own Etcd configuration below. I kindly ask you to share you= r 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 com= pact operation at around 01:00 AM?
>
> Best regards.
>
>
> [Unit]
> Description=3Detcd service
> Documentation=3Dhttps://github.com/etcd-io/etcd > After=3Dnetwork.target
>
> [Service]
> User=3Detcd
> Type=3Dnotify
> ExecStart=3D/usr/local/sbin/etcd \
>=C2=A0 =C2=A0--name etcd1 \
>=C2=A0 =C2=A0--data-dir=3D/etc/etcd \
>=C2=A0 =C2=A0--initial-advertise-peer-urls=3Dhttp://10.115.= 208.168:2380 \
>=C2=A0 =C2=A0--listen-peer-urls=3Dhttp://192.168.1.1:2380 = \
>=C2=A0 =C2=A0--listen-client-urls=3Dhttp://192.168.1.1:2379,http://127.0.0.1:2379 \
>=C2=A0 =C2=A0--advertise-client-urls=3D192.168.1.1:2379 \<= br> >=C2=A0 =C2=A0--initial-cluster-token=3D"etcd-cluster" \
>=C2=A0 =C2=A0--initial-cluster=3D"etcd1=3Dhttp://192.168.= 1.1:2380,etcd2=3Dhttp://192.168.1.2:2380,etcd3=3Dhttp://3= :2380" \
>=C2=A0 =C2=A0--initial-cluster-state=3D"new" \
>=C2=A0 =C2=A0--log-level=3D"error"
>
> [Install]
> WantedBy=3Dmulti-user.target

--00000000000071544f063ccc6f08--