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 1uojFJ-0097NP-To for pgsql-admin@arkaria.postgresql.org; Wed, 20 Aug 2025 13:52:59 +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 1uojFJ-008Vhw-Ar for pgsql-admin@arkaria.postgresql.org; Wed, 20 Aug 2025 13:52:57 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1uojFI-008Vho-R2 for pgsql-admin@lists.postgresql.org; Wed, 20 Aug 2025 13:52:57 +0000 Received: from mail-wr1-x42f.google.com ([2a00:1450:4864:20::42f]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uojFG-000qwq-2S for pgsql-admin@lists.postgresql.org; Wed, 20 Aug 2025 13:52:56 +0000 Received: by mail-wr1-x42f.google.com with SMTP id ffacd0b85a97d-3b9e4148134so3283337f8f.2 for ; Wed, 20 Aug 2025 06:52:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1755697974; x=1756302774; 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=weGUb1kMTXerOhd2asprSi/7iGXM4rijumXvz73lf9Y=; b=dzGKez+yBXDg07+xBh1HyO4037VrOmlCvGWawpuc21Zm+0gh7xTai6jMQB7Mcmhyf2 jhr1Lg125zZVTvfJ6IYU2Eplh+FKJqloRg7ROxZ83E1uoL9l+tMHx5MrGk+6qtC9ej2t l144XnUSc6q7fzL7bxpWgH2RMYGbdrwhjrqQO36ZScbJGDn4ezzlSfV20EO1vigkGdnY K4xA+QY0vR/LsnmN8xtRpiKAEwZBWgEno/+CaEAtBzvzKRzv3HLzZ9oykAjKrQaPtBHy jseslb02tUUXXqYpwAcpn1tGao9IojFDYvTaDcrGUongKqzZjKbAmJK+j4yfmxzl1S5h kmvw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1755697974; x=1756302774; 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=weGUb1kMTXerOhd2asprSi/7iGXM4rijumXvz73lf9Y=; b=TuykbME+FIy/2BLx/KSeOAOQVkDGTYt3wlRBC0i5q55fjl2XM1Pd+NbWR6meCOMMDj e7WJwjh2gDQDY6n6J1I2UN2TrTUIZ4Cv7oVcDs8yvACMZt/6YNzpZLPtz6MddI3kF6Nn KYxUHdCal1b6MjOuJRMSqLL1hjrAL/f3aN5V+45AzoOSH51DzgusGSo5f0bh8bwV2WBl uzqArKe4zePP7vy+BgYht1YStGB2lgRsitoW08aTkOZJiXqHeJr53iyWOZskSBEysRxg bi+153zTXP6suiIe4apWccfNqimM2SwELOc0XgncVlhAvWskbtz9/62UgkxeAXLDtMg5 n8bA== X-Gm-Message-State: AOJu0YybRKeFS7bIJrCYtU+MHQjeFsj9m6H3RADgcuVucFuremU1Aif7 E/trMIDwNAv9Z1b6qVCgk2q0vDnG0V1QmTpEN/JiItrWdG+FtiAfMyKM5KYc+AEya7avmteQTzj HRsd0xtdvrISRWqbk1tbRYsDdXXiMKG+5y+gzRH0= X-Gm-Gg: ASbGnctZ3ufCOblmLg/7/XkQk+bi1Y7hLy91SD655+7rrDQgpyQklpRsJvxVUOxLQRv JmKSOXsa5hnPvv9aPJD7dbLb5zws4fRnmIbF3g0EjDx0TIzYSqUBlAIcA2Yp7JrVybP/2Kmqd0h pbCRSjTxzsy+8oO0mDd0kdH/dV6HKHq8+SzhYlLcDKtq39aIVeTcmUnmmVQJQqwZzeAgJp0eg8Q LK2/r1q X-Google-Smtp-Source: AGHT+IG1dbVM8tc5nuyjIBpMcm/zEpCuClXMCZT6W8sqSgHKchqGyZJ5v8p4xzHPu9NFhGZaTKT+WwEIGsTtvoMHxpo= X-Received: by 2002:a05:6000:438a:b0:3a5:2653:7308 with SMTP id ffacd0b85a97d-3c3303dbe40mr2228058f8f.57.1755697973566; Wed, 20 Aug 2025 06:52:53 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: SOzcn Date: Wed, 20 Aug 2025 16:52:42 +0300 X-Gm-Features: Ac12FXxOntglgxrOgqjLtxG7nxCqCQrcvymeaKeiyO7awkF2wSOVOq7k8_RqTfg Message-ID: Subject: Re: PostgreSQL - HA Cluster / Etcd Issue To: Scott Ribe Cc: Pgsql-admin Content-Type: multipart/alternative; boundary="0000000000000c2450063ccc4a9a" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --0000000000000c2450063ccc4a9a Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 the > specified limit and Etcd does not clean it up through rotation. I am awar= e > of this, but despite reviewing the maintenance documentation, I could not > find the most appropriate parameter values for this rotation. I am sharin= g > 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 > > --0000000000000c2450063ccc4a9a Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
This is high availability environment and etcd is one man= agement tools of them . Many PostgreSQL managed by this architec. I advice = to you research. Etcs - Patrono - Postgresql- Haproxy- Keepalived. Anyway i= f you doesn't have experience of it, that's ok.=C2=A0

20 A=C4=9Fu 2025 =C3=87ar 15:46 tarihinde Scott Ribe <scott_ribe@elevated-dev.com> = =C5=9Funu yazd=C4=B1:
This is a Pos= tgreSQL mailing list, and your question has nothing to do with PostgreSQL.<= br>
--
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

--0000000000000c2450063ccc4a9a--