pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: configure multiple repository path in pgbackrest
Date: Wed, 5 Jun 2019 10:09:08 -0500
Message-ID: <b5fe90d0-59a3-3e13-b254-6dc1ce9ba378@gmail.com> (raw)
In-Reply-To: <CA+M0sHFTwp7S-_O_3yQ48sywwrHSGGdgQ7_ZOSCFx-O_h-FN2g@mail.gmail.com>
References: <CA+M0sHFTwp7S-_O_3yQ48sywwrHSGGdgQ7_ZOSCFx-O_h-FN2g@mail.gmail.com>



On 6/5/19 9:48 AM, Pavan Kumar wrote:
> Hello Experts,
>
> Is it possible to configure multiple backup repositories in pgbackrest 
> tool in one server?
> I am getting few issues with that.

https://pgbackrest.org/command.html#command-backup

3.4.9
Repository Path Option (--repo-path)
Path where backups and archive are stored.
The repository is wherepgBackReststores backups and archives WAL segments.

It may be difficult to estimate in advance how much space you'll need. The 
best thing to do is take some backups then record the size of different 
types of backups (full/incr/diff) and measure the amount of WAL generated 
per day. This will give you a general idea of how much space you'll need, 
though of course requirements will likely change over time as your database 
evolves.

default: /var/lib/pgbackrest
example: --repo1-path=/backup/db/backrest


Since there's a --repo*1*-path, then presumably there can also be a 
--repo2-path.

You'd presumably associate a database with repo2 by using --pg2-path

https://pgbackrest.org/command.html#command-archive-get

2.5
Stanza Options
2.5.1
PostgreSQL Path Option (--pg-path)
PostgreSQLdata directory.
This should be the same as thedata_directorysetting inpostgresql.conf. Even 
though this value can be read frompostgresql.conforPostgreSQLit is prudent 
to set it in case those resources are not available during a restore or 
offline backup scenario.

Thepg-pathoption is tested against the value reported byPostgreSQLon every 
online backup so it should always be current.

example: --pg1-path=/data/db

Deprecated Name: db-path

Of course, this might not work, so you'll have to try it yourself.

-- 
Angular momentum makes the world go 'round.

view thread (5+ messages)  latest in thread

Message-ID: <b5fe90d0-59a3-3e13-b254-6dc1ce9ba378@gmail.com>
Permalink:  ../b5fe90d0-59a3-3e13-b254-6dc1ce9ba378@gmail.com/
Also on:    postgresql.org/message-id/b5fe90d0-59a3-3e13-b254-6dc1ce9ba378@gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: ronljohnsonjr@gmail.com, pgsql-general@lists.postgresql.org
  Subject: Re: configure multiple repository path in pgbackrest
  In-Reply-To: <b5fe90d0-59a3-3e13-b254-6dc1ce9ba378@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

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