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 or /orabackup/WORM/PGBACKUP/visdemo5400/backup/v2demo/backup.info.copy ERROR [055]: : /orabackup/WORM/PGBACKUP/visdemo5400/backup/v2demo/ 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 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 <ronljohnso...@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 where pgBackRest stores 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 --repo > 2-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) > PostgreSQL data directory. > This should be the same as the data_directory setting in postgresql.conf. > Even though this value can be read from postgresql.conf or PostgreSQL it > is prudent to set it in case those resources are not available during a > restore or offline backup scenario. > > The pg-path option is tested against the value reported by PostgreSQL on > 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 *
