From: Ron <ronljohnsonjr@gmail.com>
To: pgsql-general@lists.postgresql.org
Subject: Re: configure multiple repository path in pgbackrest
Date: Wed, 5 Jun 2019 14:53:51 -0500
Message-ID: <7dc4dcf1-8724-1ed4-bbf6-0545cb21c319@gmail.com> (raw)
In-Reply-To: <CA+M0sHGqhTJJYS_8NFCrTSUm+QS32AgMizmwybcEy5+RLHKVcQ@mail.gmail.com>
References: <CA+M0sHFTwp7S-_O_3yQ48sywwrHSGGdgQ7_ZOSCFx-O_h-FN2g@mail.gmail.com>
<b5fe90d0-59a3-3e13-b254-6dc1ce9ba378@gmail.com>
<CA+M0sHGqhTJJYS_8NFCrTSUm+QS32AgMizmwybcEy5+RLHKVcQ@mail.gmail.com>
You set pg1-path and pg1-port in both v1demo and v2demo. Shouldn't v2demo
use pg2-path and pg2-port?
On 6/5/19 2:43 PM, Pavan Kumar wrote:
> Hello Ron,
>
> Thank you so much for quick response.
>
> here is my configuration.
>
> [postgres@oralnx v2demo4448]$cat /etc/pgbackrest/pgbackrest.conf
> [v1demo]
> pg1-path=/oradbaudit/pg_data_dir
> pg1-port=5400
> [v2demo]
> pg1-path=/oratrace/11_2_data
> pg1-port=4448
>
> # Backup repository configuration
> [global]
> repo1-path=/orabackup/WORM/PGBACKUP/visdemo5400
> repo1-retention-full=2
> repo2-path=/orabackup/WORM/PGBACKUP/v2demo4448
> repo2-retention-full=2
>
> [postgres@oralnx v2demo4448]$
>
> [postgres@oralnx v2demo4448]$ pgbackrest --stanza=v2demo
> --log-path=/oratrace/pg_alert_log
> --repo-path=/orabackup/WORM/PGBACKUP/v2demo4448 --log-level-console=detail
> --log-level-file=detail stanza-create
> WARN: configuration file contains invalid option 'repo2-path' >>>>>>>>
> *************
> WARN: configuration file contains invalid option 'repo2-retention-full'
> >>>>>> *********
> 2019-06-05 19:35:05.351 P00 INFO: stanza-create command begin 2.14:
> --log-level-console=detail --log-level-file=detail
> --log-path=/oratrace/pg_alert_log --pg1-path=/oratrace/11_2_data
> --pg1-port=4448 --repo1-path=/orabackup/WORM/PGBACKUP/v2demo4448
> --stanza=v2demo >>>>> ***** for some reason it took repo1- path
> 2019-06-05 19:35:06.674 P00 INFO: stanza-create command end: completed
> successfully (1324ms)
> [postgres@oralnx v2demo4448]$
>
> It got errored out when I check stanza
>
> [postgres@oralnx v2demo4448]$pgbackrest --stanza=v2demo
> --log-level-console=info check
> WARN: configuration file contains invalid option 'repo2-path'
> WARN: configuration file contains invalid option 'repo2-retention-full'
> 2019-06-05 19:36:31.188 P00 INFO: check command begin 2.14:
> --log-level-console=info --pg1-path=/oratrace/11_2_data --pg1-port=4448
> --repo1-path=/orabackup/WORM/PGBACKUP/visdemo5400 --stanza=v2demo >>>>
> *** why it is not taking repo2-path
> ERROR [055]: : unable to open
> /orabackup/WORM/PGBACKUP/visdemo5400/backup/v2demo/backup.info
> <http://backup.info; or
> /orabackup/WORM/PGBACKUP/visdemo5400/backup/v2demo/backup.info.copy
> ERROR [055]: :
> /orabackup/WORM/PGBACKUP/visdemo5400/backup/v2demo/backup.info
> <http://backup.info; does not exist and is required to perform a backup.
> HINT: has a stanza-create been performed?
> ERROR [055]: :
> /orabackup/WORM/PGBACKUP/visdemo5400/backup/v2demo/backup.info
> <http://backup.info; does not exist and is required to perform a backup.
> HINT: has a stanza-create been performed?
> 2019-06-05 19:36:32.826 P00 INFO: check command end: aborted with
> exception [055]
> [postgres@oralnx v2demo4448]$
> here is my configuration
>
>
>
> On Wed, Jun 5, 2019 at 10:09 AM Ron <ronljohnsonjr@gmail.com
> <mailto:ronljohnsonjr@gmail.com>> wrote:
>
>
>
> 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.
>
>
>
> --
> *Regards,
>
> #! Pavan Kumar
> ----------------------------------------------*-
> *Sr. Database Administrator..!*
> *NEXT GENERATION PROFESSIONALS, LLC*
> *Cell # 267-799-3182 # pavan.dba27 (Gtalk) *
> *India # 9000459083*
>
> *Take Risks; if you win, you will be very happy. If you lose you will
> be Wise *
>
--
Angular momentum makes the world go 'round.
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: <7dc4dcf1-8724-1ed4-bbf6-0545cb21c319@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