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 1r0b27-006YKU-16 for pgsql-admin@arkaria.postgresql.org; Wed, 08 Nov 2023 05:23:19 +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 1r0b25-00GBeK-Is for pgsql-admin@arkaria.postgresql.org; Wed, 08 Nov 2023 05:23:17 +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 1r0b25-00GBeC-5l for pgsql-admin@lists.postgresql.org; Wed, 08 Nov 2023 05:23:17 +0000 Received: from mail-yb1-xb2e.google.com ([2607:f8b0:4864:20::b2e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1r0b22-005IFV-8p for pgsql-admin@lists.postgresql.org; Wed, 08 Nov 2023 05:23:16 +0000 Received: by mail-yb1-xb2e.google.com with SMTP id 3f1490d57ef6-daead9cde1eso351965276.2 for ; Tue, 07 Nov 2023 21:23:14 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1699420992; x=1700025792; darn=lists.postgresql.org; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:from:to:cc:subject:date:message-id :reply-to; bh=iol9ORZLjgn6UTKSuWU2Ci2Gn8DZHyykCTbgA974LxA=; b=gtloqLj405lmdpAy23F55kXuRBH8M2e7ipjCZrd1acN5xLMLS1mf0Culo3b9qkflOs cit+KLLxK23UNPGhpx8HPAUCgqto25K7QAEbtio+tjpKJfLHh2WNdDzzmR0kyf/X2ePi npUkCUhxBzgrPVfXSFoFTSZ1brYbGxUync9y7C4Y4/pJX4Opk/0GcPXgxqqGNIwDis03 6cZ4jR0opkWWnnAvriAf6HU/CKp7kmq/6yCxAxwnzyA9JPx+a6TLw6c4j7SNZ2Px4NHc feaz/hUrKme6uu9qsvNsgNbBD71V0jFA3hs9Q6UGp6GxjmYeaB2GOwVmO3oSnBQ3lB8f 8XEg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1699420992; x=1700025792; h=in-reply-to:from:references:to:content-language:subject:user-agent :mime-version:date:message-id:x-gm-message-state:from:to:cc:subject :date:message-id:reply-to; bh=iol9ORZLjgn6UTKSuWU2Ci2Gn8DZHyykCTbgA974LxA=; b=P8/3BuUORTC+34T4Eft5hJKz2YjRIH7J23Dnj+ruvArIMmck3RILZZvBAbpxJodJmE Qmyc4thlCTj1PmXEpyNZlDx7fMfTKaBJvIE4NKnqqDlvU+2sTZp2xvzbiSqMjmYCNCNZ gnbsv/iwS4kriuO3Lr/dPaJWVGzlyrRvYfn+5ZhH5+7GQZMG/Lf/UPn6Smjjt0uTmdBW TIDrkCVrtqRxdgqHQwmKp2xB4ZXhRUxQIPaP6wjWA5G/rPRsbk5YUwT94hiutrfYFFla 9tyRSlTo9WgybI03wb2af8L3xGDrZEDgpPrN9+QWNYIKh2J8ZwO9ECNulqlSLauALRdx W+oQ== X-Gm-Message-State: AOJu0YzcLmpe5sFpyQeZKF4RtjN6okMFUDKrufhBvyj0MthhNsgRqUjY BS3XtVxQgWw03bt5pyokd1u1n5G86gA= X-Google-Smtp-Source: AGHT+IGitm0Wfhb9d/COtkiMpsikIgxrssQp+96oiUTqsqzuQmLVupvJ3htNmt4R7WglvAQb3hGdSQ== X-Received: by 2002:a25:cb0f:0:b0:d9c:7c97:7fcd with SMTP id b15-20020a25cb0f000000b00d9c7c977fcdmr898391ybg.27.1699420992125; Tue, 07 Nov 2023 21:23:12 -0800 (PST) Received: from ?IPV6:2600:1700:bd2c:b810::44? ([2600:1700:bd2c:b810::44]) by smtp.googlemail.com with ESMTPSA id k7-20020a056902024700b00d9a43500f1dsm5824045ybs.28.2023.11.07.21.23.11 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Tue, 07 Nov 2023 21:23:11 -0800 (PST) Content-Type: multipart/alternative; boundary="------------nUcUu4ULK6v0qCxwXA5gnkIP" Message-ID: <5e9191fe-6261-4355-95d5-b834725a3cb0@gmail.com> Date: Tue, 7 Nov 2023 23:23:11 -0600 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Setting Up Multiple Database Clusters in a Single pgBackRest Server Content-Language: en-US To: pgsql-admin@lists.postgresql.org References: From: Ron In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk This is a multi-part message in MIME format. --------------nUcUu4ULK6v0qCxwXA5gnkIP Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Why don't multiple stanzas in the same pgbackrest.conf solve your problem? On 11/7/23 22:30, Veerendra Pulapa wrote: > Dear Ron, > > Yes, I have read the user guide; however, I have a few questions: > > 1. How do we configure different repositories for different clusters in > the pgbackrest.conf file? > 2. How do we configure different worker processes for different cluster > pgbackrest.conf files? > 3. Are there any other points we need to consider without impacting the > existing configuration? > > > It would be great if you could share any sample configuration files that > align with my requirements. > > Br, > Veerendra Pulapa | Technical Consultant > M: +91-9949349894 | www.ashnik.com > > > > > > > > > > > > On Tue, Nov 7, 2023 at 9:03 PM Ron wrote: > > Have you read the PgBackRest User Guide? > https://pgbackrest.org/user-guide-index.html > > > On 11/7/23 09:04, Veerendra Pulapa wrote: >> Dear folks, >> >> I want to configure multiple database clusters in a single >> 'pgBackRest' server. There is one existing database cluster already >> configured. I want to add other clusters to the existing 'pgBackRest' >> server. Please guide me on how to set this up and provide details on >> the prerequisites and considerations, keeping in mind that there may >> be minimal impact during the setup process. >> >> Br, >> Veerendra Pulapa | Technical Consultant >> M: +91-9949349894 | www.ashnik.com >> >> >> >> >> >> >> >> >> > > -- > Born in Arizona, moved to Babylonia. > -- Born in Arizona, moved to Babylonia. --------------nUcUu4ULK6v0qCxwXA5gnkIP Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit Why don't multiple stanzas in the same pgbackrest.conf solve your problem?

On 11/7/23 22:30, Veerendra Pulapa wrote:
Dear Ron,

Yes, I have read the user guide; however, I have a few questions:

  1. How do we configure different repositories for different clusters in the pgbackrest.conf file?
  2. How do we configure different worker processes for different cluster pgbackrest.conf files?
  3. Are there any other points we need to consider without impacting the existing configuration?

It would be great if you could share any sample configuration files that align with my requirements.

Br,
Veerendra Pulapa | Technical Consultant
M: +91-9949349894 | www.ashnik.com



             



On Tue, Nov 7, 2023 at 9:03 PM Ron <ronljohnsonjr@gmail.com> wrote:
Have you read the PgBackRest User Guide?  https://pgbackrest.org/user-guide-index.html


On 11/7/23 09:04, Veerendra Pulapa wrote:
Dear folks,

I want to configure multiple database clusters in a single 'pgBackRest' server. There is one existing database cluster already configured. I want to add other clusters to the existing 'pgBackRest' server. Please guide me on how to set this up and provide details on the prerequisites and considerations, keeping in mind that there may be minimal impact during the setup process.

Br,
Veerendra Pulapa | Technical Consultant
M: +91-9949349894 | www.ashnik.com



             


--
Born in Arizona, moved to Babylonia.

--
Born in Arizona, moved to Babylonia.
--------------nUcUu4ULK6v0qCxwXA5gnkIP--