Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hUEjz-00022c-ES for pgsql-admin@arkaria.postgresql.org; Fri, 24 May 2019 18:16:27 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hUEjy-0008WG-5P for pgsql-admin@arkaria.postgresql.org; Fri, 24 May 2019 18:16:26 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hUEjx-0008Tg-Hs for pgsql-admin@lists.postgresql.org; Fri, 24 May 2019 18:16:25 +0000 Received: from mail-ot1-x32c.google.com ([2607:f8b0:4864:20::32c]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hUEju-0005dk-St for pgsql-admin@lists.postgresql.org; Fri, 24 May 2019 18:16:24 +0000 Received: by mail-ot1-x32c.google.com with SMTP id g18so9489876otj.11 for ; Fri, 24 May 2019 11:16:22 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-language; bh=nH90loDXAxNV+tyg4Qp87PLcgK+juojkpJZEEUc2BJ0=; b=irIhCNLrLt5EBklhwIJ4Qckg30ghDiZb9BGRzYsbvy7M9f6N4r8nnCwMFlWOnNkwr4 rWCFLXAIIqMAxxW4VNBemlSBIUfrmc1W0aIzZcTHJ19QkCUJ60QLq+bxYGdDWiVV+TRv G6eLfwiHjdku89ARBELXu7n0moJy8ODDEmYgEoaItdeJqww8DOxjFhC3jPTlK7BPzi88 PmeSfkRr61irejX5d8Qb3OGnsB9ZAGAulpRXdlU9FY237W4zyPimTCmSMwlDoDLQVyuL zsyB8xpBn3yaShcs0N6MpSscNM36wMwAk7r1bhv1WGgUl2yrJZk89Hhq63vQH7GGmYa0 QYKQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-language; bh=nH90loDXAxNV+tyg4Qp87PLcgK+juojkpJZEEUc2BJ0=; b=U/C797SaESlFfiCS++UwrHabtdp3SlFx4FN+O6AlgneqB4hKUZgEeE6mqIl0L0Bj5I 9jYTuGWor0oOOf/cLS/0Nx68DyYh7LGIl2SyF0JTof+GHASnKZ/snf5FmGbxh1JA7FeM t3AU9Qrw5szZdnTbsWjOrHO4rMze7fEfjMs5VNT1u1XkW86g+0XXysw8EJnI9syJgWeP wInzQ1QruH7uIbzk2gdgjfh/qv24+w74wy96XC0RDpXtWNbGIFxHVYY8tmfRM5XOWLJV Gp8Gag3rvsaEYFXLcOVOjhv4Jfpk6eH9SL5ay7EfkZLIG5PeQqivZeraSQcOtm2997Mc 385g== X-Gm-Message-State: APjAAAVIRCzBa6Kkl5ONZWsvngiIotjUQp5IqnmKPh5Of3HzquEl+v5H Ig34/jAboOYjkuNSn8E/AkwUp6/6eKlxGw== X-Google-Smtp-Source: APXvYqw+OuMLPUCU58Q+Bxl2ATiilcl2xswZmvGwL/0BlQyb0Lwv49b15u3SofDDVSdhQKYaLJMk0g== X-Received: by 2002:a05:6830:16d2:: with SMTP id l18mr30039747otr.303.1558721781809; Fri, 24 May 2019 11:16:21 -0700 (PDT) Received: from [192.168.1.10] (ip70-171-116-89.no.no.cox.net. [70.171.116.89]) by smtp.googlemail.com with ESMTPSA id g5sm1119039otn.5.2019.05.24.11.16.20 for (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Fri, 24 May 2019 11:16:21 -0700 (PDT) Subject: Re: pg_backrest build dependencies rpm's To: pgsql-admin@lists.postgresql.org References: <3fafbf1d-7fa4-09a9-cd69-8532df0d5a67@disroot.org> <5f1aeb58-2c06-e617-58db-bf429c3fd9f7@disroot.org> <178d1402-6770-279c-d4e8-5610e08c77fc@pgmasters.net> From: Ron Message-ID: Date: Fri, 24 May 2019 13:16:20 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.6.1 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------9F40BC883E6EF023A5D7F589" Content-Language: en-US List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is a multi-part message in MIME format. --------------9F40BC883E6EF023A5D7F589 Content-Type: text/plain; charset=utf-8; format=flowed Content-Transfer-Encoding: 8bit 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@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@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 > 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@pgmasters.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. --------------9F40BC883E6EF023A5D7F589 Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: 8bit On 5/24/19 12:12 PM, Pavan Kumar wrote:
David and Jakub,

Thank you so much for reply.


 I was able to install pgbackrest  tool. when I tried to create stanza, I got below error. kindly help us on this.

[root@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@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@pgmasters.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@pgmasters.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.
--------------9F40BC883E6EF023A5D7F589--