Re: pg_backrest build dependencies rpm's

Hello Ron,

I was able to fix the problem by adding pg1-port In
/etc/pgbackrest/pgbackrest.con file

cat /etc/pgbackrest/pgbackrest.conf
[visa-demo]
pg1-path=/oradbaudit/pg_data_dir
pg1-port=5400

pgbackrest --stanza=visa-demo --log-path=/oratrace/pg_alert_log
--repo-path=/orabackup/WORM/PGBACKUP/visa-demo-5400
--log-level-console=detail --log-level-file=detail stanza-create
2019-05-24 17:47:48.360 P00 INFO: stanza-create command begin 2.14:
--log-level-console=detail --log-level-file=detail
--log-path=/oratrace/pg_alert_log --pg1-path=/oradbaudit/pg_data_dir
--pg1-port=5400 --repo1-path=/orabackup/WORM/PGBACKUP/visa-demo-5400
--stanza=visa-demo
2019-05-24 17:47:49.778 P00 INFO: stanza-create command end: completed
successfully (1419ms) >>>>>>>>>>.. created

On Fri, May 24, 2019 at 1:16 PM Ron <ronljohnsonjr(at)gmail(dot)com> wrote:

> On 5/24/19 12:12 PM, Pavan Kumar wrote:
>
> David and Jakub,
>
> Thank you so much for reply.
>
> https://pgbackrest.org/user-guide-centos7.html#build
>
> I was able to install pgbackrest tool. when I tried to create stanza, I
> got below error. kindly help us on this.
>
> [root(at)oralnx1 ~]# su - postgres
> -bash-4.2$ source pg_5400_env.sh >>>> I have sourced my 11.2 version
> environment variables
>
> >>>>> tried to created stanza
>
> postgres(at)oralnx1 ~> pgbackrest --stanza=visa-demo
> --log-path=/oratrace/pg_alert_log
> --repo-path=/orabackup/WORM/PGBACKUP/visa-demo-5400
> --log-level-console=detail --log-level-file=detail stanza-create
> 2019-05-24 16:44:52.671 P00 INFO: stanza-create command begin 2.14:
> --log-level-console=detail --log-level-file=detail
> --log-path=/oratrace/pg_alert_log --pg1-path=/oradbaudit/pg_data_dir
> --repo1-path=/orabackup/WORM/PGBACKUP/visa-demo-5400 --stanza=visa-demo
> ERROR [058]: : version '10' and path '/oratrace/pgdata_10.8' queried from
> cluster do not match version '11' and pg1-path '/oradbaudit/pg_data_dir'
> read from '/oradbaudit/pg_data_dir/global/pg_control'
> HINT: the pg1-path and pg1-port settings likely reference different
> clusters
> 2019-05-24 16:44:53.906 P00 INFO: stanza-create command end: aborted
> with exception [058]
>
> problem Is I do have postgres version 10 and 11 on same server. why
> pgbackrest is taking version 10 ?
>
>
> What's in your /etc/pgbackrest.conf file?
>
>
> please advise
>
> On Fri, May 24, 2019 at 6:16 AM David Steele <david(at)pgmasters(dot)net> wrote:
>
>> On 5/24/19 3:16 AM, Jakub Olczyk wrote:
>> >>
>> >> Instead of configuring pgdg yum repository, is there any way to
>> download rpm's from pgdg repository portal ?
>> >
>> > Well, I thought you might want to use the prepackaged version of
>> > pgbackrest from the repository that matches the version of PostgreSQL
>> > you have installed. So the command after installing the repository RPM
>> > would look like this:
>> >
>> > # yum install pgbackrest
>> >
>> > In that way you won't need to compile anything from scratch and you can
>> > count on the automated updates from the repository.
>>
>> Using the packages available from yum.postgresql.org is generally the
>> best idea.
>>
>> If you must build from source the instructions for RHEL7 can be found
>> here:
>>
>> https://pgbackrest.org/user-guide-centos7.html#build
>>
>> --
>> -David
>> david(at)pgmasters(dot)net
>>
>
>
> --
>
>
>
> *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.
>

--

*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 *