pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedSetting Up Multiple Database Clusters in a Single pgBackRest Server
6+ messages / 2 participants
[nested] [flat]
* Setting Up Multiple Database Clusters in a Single pgBackRest Server
@ 2023-11-07 15:04 Veerendra Pulapa <veerendra.pulapa@ashnik.com>
2023-11-07 15:32 ` Re: Setting Up Multiple Database Clusters in a Single pgBackRest Server Ron <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Veerendra Pulapa @ 2023-11-07 15:04 UTC (permalink / raw)
To: pgsql-admin
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
<https://www.ashnik.com/;
<https://www.linkedin.com/company/ashnik-pte-ltd/;
<https://www.facebook.com/AshnikBiz;
<https://www.youtube.com/user/ashnikbiz;
<https://www.instagram.com/ashnikbiz/; <https://twitter.com/Ashnikbiz;
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Setting Up Multiple Database Clusters in a Single pgBackRest Server
2023-11-07 15:04 Setting Up Multiple Database Clusters in a Single pgBackRest Server Veerendra Pulapa <veerendra.pulapa@ashnik.com>
@ 2023-11-07 15:32 ` Ron <ronljohnsonjr@gmail.com>
2023-11-08 04:30 ` Re: Setting Up Multiple Database Clusters in a Single pgBackRest Server Veerendra Pulapa <veerendra.pulapa@ashnik.com>
0 siblings, 1 reply; 6+ messages in thread
From: Ron @ 2023-11-07 15:32 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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 <http://www.ashnik.com;
>
> <https://www.ashnik.com/;
>
>
> <https://www.linkedin.com/company/ashnik-pte-ltd/;
> <https://www.facebook.com/AshnikBiz;
> <https://www.youtube.com/user/ashnikbiz;
> <https://www.instagram.com/ashnikbiz/; <https://twitter.com/Ashnikbiz;
>
--
Born in Arizona, moved to Babylonia.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Setting Up Multiple Database Clusters in a Single pgBackRest Server
2023-11-07 15:04 Setting Up Multiple Database Clusters in a Single pgBackRest Server Veerendra Pulapa <veerendra.pulapa@ashnik.com>
2023-11-07 15:32 ` Re: Setting Up Multiple Database Clusters in a Single pgBackRest Server Ron <ronljohnsonjr@gmail.com>
@ 2023-11-08 04:30 ` Veerendra Pulapa <veerendra.pulapa@ashnik.com>
2023-11-08 05:23 ` Re: Setting Up Multiple Database Clusters in a Single pgBackRest Server Ron <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Veerendra Pulapa @ 2023-11-08 04:30 UTC (permalink / raw)
To: Ron <ronljohnsonjr@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
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
<https://www.ashnik.com/;
<https://www.linkedin.com/company/ashnik-pte-ltd/;
<https://www.facebook.com/AshnikBiz;
<https://www.youtube.com/user/ashnikbiz;
<https://www.instagram.com/ashnikbiz/; <https://twitter.com/Ashnikbiz;
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
>
> <https://www.ashnik.com/;
>
>
> <https://www.linkedin.com/company/ashnik-pte-ltd/;
> <https://www.facebook.com/AshnikBiz;
> <https://www.youtube.com/user/ashnikbiz;
> <https://www.instagram.com/ashnikbiz/; <https://twitter.com/Ashnikbiz;
>
>
> --
> Born in Arizona, moved to Babylonia.
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Setting Up Multiple Database Clusters in a Single pgBackRest Server
2023-11-07 15:04 Setting Up Multiple Database Clusters in a Single pgBackRest Server Veerendra Pulapa <veerendra.pulapa@ashnik.com>
2023-11-07 15:32 ` Re: Setting Up Multiple Database Clusters in a Single pgBackRest Server Ron <ronljohnsonjr@gmail.com>
2023-11-08 04:30 ` Re: Setting Up Multiple Database Clusters in a Single pgBackRest Server Veerendra Pulapa <veerendra.pulapa@ashnik.com>
@ 2023-11-08 05:23 ` Ron <ronljohnsonjr@gmail.com>
2023-11-08 05:36 ` Re: Setting Up Multiple Database Clusters in a Single pgBackRest Server Veerendra Pulapa <veerendra.pulapa@ashnik.com>
0 siblings, 1 reply; 6+ messages in thread
From: Ron @ 2023-11-08 05:23 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
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 <http://www.ashnik.com;
>
> <https://www.ashnik.com/;
>
>
> <https://www.linkedin.com/company/ashnik-pte-ltd/;
> <https://www.facebook.com/AshnikBiz;
> <https://www.youtube.com/user/ashnikbiz;
> <https://www.instagram.com/ashnikbiz/; <https://twitter.com/Ashnikbiz;
>
>
>
> 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 <http://www.ashnik.com;
>>
>> <https://www.ashnik.com/;
>>
>>
>> <https://www.linkedin.com/company/ashnik-pte-ltd/;
>> <https://www.facebook.com/AshnikBiz;
>> <https://www.youtube.com/user/ashnikbiz;
>> <https://www.instagram.com/ashnikbiz/; <https://twitter.com/Ashnikbiz;
>>
>
> --
> Born in Arizona, moved to Babylonia.
>
--
Born in Arizona, moved to Babylonia.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Setting Up Multiple Database Clusters in a Single pgBackRest Server
2023-11-07 15:04 Setting Up Multiple Database Clusters in a Single pgBackRest Server Veerendra Pulapa <veerendra.pulapa@ashnik.com>
2023-11-07 15:32 ` Re: Setting Up Multiple Database Clusters in a Single pgBackRest Server Ron <ronljohnsonjr@gmail.com>
2023-11-08 04:30 ` Re: Setting Up Multiple Database Clusters in a Single pgBackRest Server Veerendra Pulapa <veerendra.pulapa@ashnik.com>
2023-11-08 05:23 ` Re: Setting Up Multiple Database Clusters in a Single pgBackRest Server Ron <ronljohnsonjr@gmail.com>
@ 2023-11-08 05:36 ` Veerendra Pulapa <veerendra.pulapa@ashnik.com>
2023-11-08 08:12 ` Re: Setting Up Multiple Database Clusters in a Single pgBackRest Server Ron <ronljohnsonjr@gmail.com>
0 siblings, 1 reply; 6+ messages in thread
From: Veerendra Pulapa @ 2023-11-08 05:36 UTC (permalink / raw)
To: Ron <ronljohnsonjr@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
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
>
> <https://www.ashnik.com/;
>
>
> <https://www.linkedin.com/company/ashnik-pte-ltd/;
> <https://www.facebook.com/AshnikBiz;
> <https://www.youtube.com/user/ashnikbiz;
> <https://www.instagram.com/ashnikbiz/; <https://twitter.com/Ashnikbiz;
>
>
> 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
>>
>> <https://www.ashnik.com/;
>>
>>
>> <https://www.linkedin.com/company/ashnik-pte-ltd/;
>> <https://www.facebook.com/AshnikBiz;
>> <https://www.youtube.com/user/ashnikbiz;
>> <https://www.instagram.com/ashnikbiz/;
>> <https://twitter.com/Ashnikbiz;
>>
>>
>> --
>> Born in Arizona, moved to Babylonia.
>>
>
> --
> Born in Arizona, moved to Babylonia.
>
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Setting Up Multiple Database Clusters in a Single pgBackRest Server
2023-11-07 15:04 Setting Up Multiple Database Clusters in a Single pgBackRest Server Veerendra Pulapa <veerendra.pulapa@ashnik.com>
2023-11-07 15:32 ` Re: Setting Up Multiple Database Clusters in a Single pgBackRest Server Ron <ronljohnsonjr@gmail.com>
2023-11-08 04:30 ` Re: Setting Up Multiple Database Clusters in a Single pgBackRest Server Veerendra Pulapa <veerendra.pulapa@ashnik.com>
2023-11-08 05:23 ` Re: Setting Up Multiple Database Clusters in a Single pgBackRest Server Ron <ronljohnsonjr@gmail.com>
2023-11-08 05:36 ` Re: Setting Up Multiple Database Clusters in a Single pgBackRest Server Veerendra Pulapa <veerendra.pulapa@ashnik.com>
@ 2023-11-08 08:12 ` Ron <ronljohnsonjr@gmail.com>
0 siblings, 0 replies; 6+ messages in thread
From: Ron @ 2023-11-08 08:12 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
*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 <http://www.ashnik.com;
>>
>> <https://www.ashnik.com/;
>>
>>
>> <https://www.linkedin.com/company/ashnik-pte-ltd/;
>> <https://www.facebook.com/AshnikBiz;
>> <https://www.youtube.com/user/ashnikbiz;
>> <https://www.instagram.com/ashnikbiz/; <https://twitter.com/Ashnikbiz;
>>
>>
>>
>> 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 <http://www.ashnik.com;
>>>
>>> <https://www.ashnik.com/;
>>>
>>>
>>> <https://www.linkedin.com/company/ashnik-pte-ltd/;
>>> <https://www.facebook.com/AshnikBiz;
>>> <https://www.youtube.com/user/ashnikbiz;
>>> <https://www.instagram.com/ashnikbiz/;
>>> <https://twitter.com/Ashnikbiz;
>>>
>>
>> --
>> Born in Arizona, moved to Babylonia.
>>
>
> --
> Born in Arizona, moved to Babylonia.
>
--
Born in Arizona, moved to Babylonia.
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2023-11-08 08:12 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-11-07 15:04 Setting Up Multiple Database Clusters in a Single pgBackRest Server Veerendra Pulapa <veerendra.pulapa@ashnik.com>
2023-11-07 15:32 ` Ron <ronljohnsonjr@gmail.com>
2023-11-08 04:30 ` Veerendra Pulapa <veerendra.pulapa@ashnik.com>
2023-11-08 05:23 ` Ron <ronljohnsonjr@gmail.com>
2023-11-08 05:36 ` Veerendra Pulapa <veerendra.pulapa@ashnik.com>
2023-11-08 08:12 ` Ron <ronljohnsonjr@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox