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 1r0dfs-006vWz-4X for pgsql-admin@arkaria.postgresql.org; Wed, 08 Nov 2023 08:12:32 +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 1r0dfp-000Tp6-OG for pgsql-admin@arkaria.postgresql.org; Wed, 08 Nov 2023 08:12:29 +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 1r0dfp-000Tnq-44 for pgsql-admin@lists.postgresql.org; Wed, 08 Nov 2023 08:12:29 +0000 Received: from mail-yw1-x1133.google.com ([2607:f8b0:4864:20::1133]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1r0dfm-004X1s-9o for pgsql-admin@lists.postgresql.org; Wed, 08 Nov 2023 08:12:27 +0000 Received: by mail-yw1-x1133.google.com with SMTP id 00721157ae682-5b499b18b28so79546887b3.0 for ; Wed, 08 Nov 2023 00:12:26 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1699431145; x=1700035945; 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=sHUuJUP+htMBG9FrYQ8MtPJnWzbArOEqf4bh/8MXNOs=; b=OBRyx+CvICbhTdWMCbgDmRiaSL0oL9lcgGxdi16qWQN7eGuLmUgFhNHhK49QV3BwO4 VJQ9/hA3kVP1YHl47ZjSibskIcuWTwn0YSWFrPfHr1j/OIcXKZK6U/55jMvKhBflQd3I H1zhWViRtK4RBkUvkZbJESnAMZkYqB9pgwwimlWWipMzfUO3e/2SYqcCWn6msbRQkFkv 3RX/VXxjUC+GB8etf9cF19O0/ZJ190SrRHeVHJjTLjpQoXZNS1iqli9cPwAC1BM68DHv S325moqshcSiCF2bf3a702wK02KUBKOF6FxLWELCXzYCXZZI4AwZh1zusA+a3Y8irKC/ 5/gA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1699431145; x=1700035945; 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=sHUuJUP+htMBG9FrYQ8MtPJnWzbArOEqf4bh/8MXNOs=; b=nf8Re3koecBC+MFGE47sHqxu3r6PReMjXQ5r07b0yEd/lihCMbGNnD2ypEBUxm9l3d S2bTrBml5BZfCW20qjDTs5L9OAuF2ATzdhUKniu0jfa/BxE/POCXYFGX4qexIyQ5j/12 angP+tE5WjC0b8J4S6jb4UEnChb1GvtGJymyrgmMnhz0iN3VTF+4Xp8QUk7uCIbMD1Qu v/jmk+MO8oAtm5gvj6/ujzYf5l4qDmTTWo7g5kNibjlOfQlW8WdCfYdkjYCocEC7lnQ9 qKsUbFdzYdeBehOC15veykdV1EmPQw0NI79E9onfNsm3HP4V92VgL2wxWemo0et3oZ+Z 3fUQ== X-Gm-Message-State: AOJu0YweosCjaDcTZtRIMT5cSGnrdBdBbT2ltbhwjD5Ax/0IvsJRlbYa pJyQLU7bUixX/mMFr5GNWNxjh8CsZzE= X-Google-Smtp-Source: AGHT+IGHTigiCSkVjQJ0/nHPo3OgY9n4bMp0C+hIlMgljh7Q9O8QDjLP4qOvcAUM1XPMueAlDnKKfg== X-Received: by 2002:a0d:eb0d:0:b0:5a7:aa54:42b1 with SMTP id u13-20020a0deb0d000000b005a7aa5442b1mr1067376ywe.28.1699431144656; Wed, 08 Nov 2023 00:12:24 -0800 (PST) Received: from ?IPV6:2600:1700:bd2c:b810::44? ([2600:1700:bd2c:b810::44]) by smtp.googlemail.com with ESMTPSA id l66-20020a0de245000000b005a23ab90366sm6646124ywe.11.2023.11.08.00.12.24 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 08 Nov 2023 00:12:24 -0800 (PST) Content-Type: multipart/alternative; boundary="------------UE56lz5zZYnvHflEL1FKHg00" Message-ID: <886008cc-c74f-452f-97b8-cd421d04e017@gmail.com> Date: Wed, 8 Nov 2023 02:12:23 -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: <5e9191fe-6261-4355-95d5-b834725a3cb0@gmail.com> 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. --------------UE56lz5zZYnvHflEL1FKHg00 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit *Stanzas*. On 11/7/23 23:36, Veerendra Pulapa wrote: > Same configuration will be solve my case. How do we configure different > repo paths for each cluster? > > On Wed, 8 Nov 2023 at 10:53, Ron wrote: > > 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. > -- Born in Arizona, moved to Babylonia. --------------UE56lz5zZYnvHflEL1FKHg00 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 8bit Stanzas.

On 11/7/23 23:36, Veerendra Pulapa wrote:
Same configuration will be solve my case. How do we configure different repo paths for each cluster?

On Wed, 8 Nov 2023 at 10:53, Ron <ronljohnsonjr@gmail.com> wrote:
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.

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